I have a workbook with a lot of data that (using a looping macro) we create
1200+ separate workbooks using 4 tabs from the original workbook. I am
running into an issue now that on one of the tabs that is copied over to the
new workbook we include a graph. When I go to create one ...

How do I set excel to prompt me when numbers are duplicated?

I have a pivot table where I want to do some calculations.
The fields are as follows:
Rowfield:
Name

Problem Description:
1. Some of the users are unable to open Excel files and save it on the same
location on a file share
2. Error message reads "changes couldn’t be saved and was saved to temporary

I created a color-coded spreadsheet and and a Key.  I don't want the key at
the top, but it will get lost at the bottom.  Is there a way to group the Key
cells together and have them "float" - almost like a toolbar?
Thanks,

Regarding Excel 2003 - I copied a range of (what I thought were) numbers from
a webpage into a sheet. When I then tried to work with these numbers I got
the above error message. In tracing the formula problem, there appeared in
the trace box a double quote (") ahead of the number ...

I understand how to group data when it's transferred to Excel as pivot-
table.  However I was wondering if it's possible to group before the
data is returned to excel (i.e. from the wizard directly up-front).
The problem is that I'm trying to query, externally via ODBC, in a

I am trying to figure out a formula and it uses the ^ character in it, what
does this mean?

I need to have a macro or code that will find a value the user inputs (in a
textbox) and finds it on another sheet in column B.  
Thanks

Why excel 2007 didn't support dbase, excel 3.0, excel 4.0 and others file
type as excel 2003?
Since the excel 2007 didn't support dbase file type, what can i do if I want
save the dbase file type?

In Excel 2003 "save as" gives various options to save in 123 formats, yet my
excel 2007 does not give any such options.
How do I get these options in excel 2007?
Thanks in advance.

I am using excel as a db and pulling data to Word to print some labels. In
my excel file there is a date column which takes date values like DD/MM/YYYY
correctly but when this date come to Word unfortunetly it loses its format
and it becomes MM/DD/YYYY

Could someone please advise me a nice simple formula for giving an average
for non zero entries. The average function in Excel provides an average of a
list of numbers including numbers that are zero. I need the average of just a
series of numbers where zeros are not considered ...

I changed the font in a cell to New Times Roman, but the text is still
displayed in the a Sans Serif font.  When I click on the cell with text it
says New Times Roman.
Why isn't the text displayed in the Font that is applied to a particular cell?