I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook.  It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.

I am trying to create a floating toolbar on the fly with dropdown menus and
also first level buttons. I cannot figure out how to assign an icon to a
button. Here is a piece of the code where I would like to assign an icon to
the Calculate button. How do I assign the ICON picture?

I have a named range of cells (called xcodes) in a single column that
is in the following format:
D123 - Department Text Description Here.
All entries have 4 characters proceeded with a description just as

I have properly purchased a Microsoft Office Professional Edition 2003 and
installed it on my computer.
In running the VBA Editor in Excel, I have went to the Tools>Additional
Controls> and downloaded the Microsoft Common Dialog into the toolbox.

I can see the gridlines in the worksheet, and I have Show and Print
gridlines checked, but a print preview or print do not produce the
gridlines.
What am I missing?

Re : Excel HyperLink by OffSet Leaping to Active Selection
1. Enter an Excel worksheet and a relatively small tabulation named
TabLet thereof.
2. TabLet takes the range of say, B2:C18.

I'm working with a spreadsheet that is exported from a phone time-clocking
service.  Basically, employees call a phone number, choose an option to
either punch in or out, and the service tracks these punches throughout the
week.  At the end of the week, all data is exported into ...

I use Excel 2000
I have a worksheet that has duplicate (or more) entries in some columns.
When I generate the pivot table these items that are duplicated only display
once on the table and there is a blank line/s under them.

I have a spreadsheet with 2 columns: Column 1: Names, Column 2: Dates, where
each Date cell contains a comma-delimited list of dates.
For example:
Name          : Dates

I am using the following formula to compute the week number based on
the ISO standard ISO8601:2000
=INT((B4-DATE(YEAR(B4-WEEKDAY(B4-1)+4),1,3)+WEEKDAY(DATE(YEAR(B4-
WEEKDAY(B4-1)+4),1,3))+5)

I currently have a workbook that I add a new worksheet to each week.  I am
trying to track work orders - how many, if they are returned within a
suitable time frame and if work gets cancelled. My system right now is pretty
basic - download list from our database onto an excel ...

I am having trouble replacing exact cell references with named ranges in my
formulas.
Why does the following (with exact cell references) work:
=SUMPRODUCT((DOCs!P408:P701="TF")*(DOCs!O408:O701="Y"))

I am working in Excel 2007 & OS is Windows Vista.
I want to have a cell displaying text 'Bank Accounts'. When a user
click or moves the cursor on this cell, there should a drop-down list
of all bank accounts. Each of these drop down should be hyperlinked to

Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise

Once again I'm struggling with the 'Custom' option in Data Validation.
I have a cell formatted as 'Date' (assume A1).
I want the user to be able to enter any valid date greater than (say)
01/01/2000.