I get "too many formats" in Excel

[LenL]

I have a fairly long Excel program (5 megabytes) that analyzes splits in a
swim meet. I am getting "too many formats". How can I get Excel 2003 to
increase the number of formats it will accept?

 

[Pete_UK]

You can't (unless you upgrade to XL 2007) - you'll just have to
simplify the formatting applied in your workbook.

Hope this helps.

Pete

 

[FSt1]

hi
sorry, you've hit a ceiling. 2003 only allows 4000 different combinations of
cell formats. 2007 increased that to 64000 (due to the larger sheets) but it
is a ceilling and the only real solution is ....don't exceed the limit.
see this site for more detail and possible fixes.
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

regards
FSt1