Too many cell formats

  • Thread starter Thread starter ldavis
  • Start date Start date
L

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?
 
... "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
Click to expand...

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!
 
Back
Top