A Weird One: "Too Many Formats"

[Random NumNuts]

I have a fairly large workbook with about 12 tabs. No graphs; but a bunch of
text blocks, tables, etc.

Every once in a while I get the "Too many formats" error. Sometimes it goes
away if I close and reopen the workbook. One time, though, I couldn't even
open the workbook - got the error insetaed.

Anyone ever come across this one? (I do have a bunch of custom formats, but
not a ton; also have about 20 names).

Thanks... Randy

 

[Ron de Bruin]

Here is some information

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

David McRitchie posted this

Leo Heuser posted a macro 2001-05-06 in programming as a very major revision of the macro in the eee007 article.
http://groups.google.com/groups?selm=OxP9cgi1AHA.1572@tkmsftngp02

 

[Frank Kabel]

Hi
have a look at the following KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

 

[David McRitchie]

Hi Randy,

This used to be a big problem for a lot of us.

http://www.mvps.org/dmcritchie/excel/slowresp.htm#formats

Check over the above, see if you get past your problem, and just
out of curiosity, what version of Excel, and what Operating System.

 

[Random NumNuts]

Thanks all for your quick responses -- now I understand the issues , but not
happy about the limitation. Oh well...

..../R