Too many cell formats

[ldavis]

while formatting a cell I got a dialog box that says "too
many cell formats" I saved the file, but when I tried to
open it again I got the same dialog box and the file
woill not open.. any ideas or comment?

 

[Frank Kabel]

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

 

[Max]

... "too many cell formats"

Check out these 2 previous posts by MVP Leo Heuser,
where he provides 2 VBA subs to deal with it.

Sub DeleteUnusedStyles()
http://tinyurl.com/mmrd

Sub DeleteUnusedCustomNumberFormats()
[version 1.01]
http://tinyurl.com/37vz7

As for your comment ..

.. and the file woill not open

Maybe try a power down and then restart
before opening the file?

[ that's what I'd do when Excel goes awry ... and it does help
... perhaps something to do with clearing the RAM ]

Good luck!