Excel Error - Too many different cell formats.
 

Why did it occur and how do I correct it?

Excel Error - Too many different cell formats.
 

It occurs because there is a limit to the number of different formats
that Excel can keep track of.

You can correct it by reducing the number of different formats you
have. For example, click on the intersection of the row and column
identifiers to highlight the whole sheet (or CTRL-A twice for XL2002
and later) then set the font and font size for the whole sheet in one
operation, rather than individually for each cell. While you have the
cells highlighted, you can set the background colour and foreground
colour for the whole sheet, turn off any borders, emboldening,
undelining etc etc. by making use of Format | Cells.

Hope this helps,

Pete

On Nov 12, 6:41*pm, barb wrote:
Why did it occur and how do I correct it?

Excel Error - Too many different cell formats.
 

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
version.

http://www.openoffice.org, a 60-104 meg download or a CD

barb wrote:

Why did it occur and how do I correct it?

--

Dave Peterson