Too many different cell formats error message in Excel

  • Thread starter Thread starter DTAmn
  • Start date Start date
D

DTAmn

I have a spreadsheet (xls) that when I try to open in Excel 2003 gives me
"Too many different cell formats" and the file cannot be opened.

If I use Excel 2007 I can open the file in compatibility mode and all the
formats are there.
When I run compatibility test I get no errors.
I know there is a 4000 cell formats limit but this scenario looks like a bug
since I am running in 2003 compatibility mode.

I am trying to find out how many formats are there but can only get the
number of styles which is around 100.

Any suggestions?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...371fa5e&dg=microsoft.public.excel.crashesgpfs
 
Hi,

I suspect it is not a bug. When you open in compatibility mode you can use
any of the color from the various drop downs, such as Fill, Font and so on.
there are 16 Million colors in 2007 but only 56 in 2003 but you can still use
all 16 million while Excel 2007 has the file open.

My suggestion is that you reduce the number of cell styles in your workbook
to less than 4000. If that presents a problem you might consider breaking up
the workbook into two and eliminating the style which aren't necessary from
each to get the numbers down.
 
I have only 100 styles.
I cannot tell how many formats I have.
Also if I open xls file in compatibility mode I would expect that
it will be compatible with Excel 2003.

Is there a way to find out how many formats are available?
 
I understand the difference between style and formats.
I need to know just one thing:
Is there a way to find out how many formats are already in my spreadsheet?
Any VBA code or .net API etc...


Thanks
 
Back
Top