When I open Excel 2007, whether for a new spreadsheet or for an existing one,
I get an error message 'Invalid Format - anotherfilename.doc' If I click OK
then Excel appears to function normally. The 'anotherfilename.doc' is always
the same file. Does anyone have any ideas please?

I was wondering if there was a way to count the amount of times that
something occurs based on two sets of data.  Take for example a list of
people's favorite fruits and sports:
Fruit                   Sports

I was hoping someone could help me out in making the #div/0 error
removed and replaced by a 0.
Here is my formulal:
=AVERAGE(IF('Filled All'!I1:I1000="JS",IF('Filled All'!

I have a table with 3 rows with a multitude of columns.  If we look at one
column, each cell is simply the summation of values (ie: =120+65+15)
So I end up with a a column looking with totals looking like
220

I have a 2-sheet workbook with one see being an overview with formulas
in it.  The second sheet is raw data in 8 columns that I pull every
month.  My question is:
How can I make it so that each month, when I paste in the new data,

Hi,
How do you  format a cell so that it is right-aligned but indented (from the
right) so the data is not right up against the side of the cell?
You can do this with left align (indent it from the left), but in my version

I do not yet know macros.  I would like to create a label template allowing
information to be written and that would automatically add a label #.  Any
suggestions would be appreciated.

I have a formula in a cell that is formated as a percentage. I need the
formula results to be in red if the value is a negative number. How do I do
that?

Wanted to export three hundred first/last names into a template for a dean's
list.  Any suggestions?

How do I do the following please...
Cell A1 contains a number from 1 to 100.
Cells B1-B100 (depending on nr in cell A1) will be filled with blue.
i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue.

I have several identical workbooks setup for each user, i need to update
these workbooks without changing any of the data that they have input. While
i can into each workbook individually and update the worksheets within thm,
would there be a way to perform a mass update on each ...

I have a workbook that has several worksheets init that are alike. They
populate averages for grades. But there are comment blocks for input from the
evaluators. Some evaluators like to make their comments in bullets and use
"=" or  "-" which turns on a green light for the ...

I am using Excel in Office XP. I have a set of values pertaining to a unique
identifier. These unique id's would be a range from say 1230000000 to
1230099999 for one manufacturer and and I have named this range "UPC." There
are other manufacturers with similar ranges and my ...

I have been looking for an entire day to find a solution to this. Found
'some' answers but not the thing I need.
I got a few workbooks with a lot of worksheets. For almost every workbook
there needs to be a list of unique values coming from different worksheet

How can I add the OneNote 2007 icon to the ribbon in Excel 2007?  The icon is
in the ribbon in Outlook 2007 but none of the other functions.