What to do to stop error msg: "Too many different cell formats"?

G

Guest

Working on quite large spreadsheet, I keep getting "Too many different cell
formats" error message — even when trying to make fairly simple changes to a
handful of cells. Once message has appeared, can't then even make single
change to single cell without it popping up again. Only workround is to quit
and restart programme. It happens repeatedly; it's driving me nuts.
 
N

Nick Hodge

Spuddie

Without stating the obvious. You'll need top cut down the number of cell
formats used. A format is *any* different part of a format, e.g size, font,
colour, bold, etc. You can cut these down by using styles. (Format>Styles)

If you cannot change anything, then, if you are on a version of XL pre-2002,
try opening in 2002/3 and make your changes and you should then be ok

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'too many different cell fomats' 2
"Too many cell formats"? 2
What causes the "Too many different cell formats" error in Excel 2
excel restarts on error "too many cell formats" 1
Too Many Cell Formats Error 3
Too Many Cell Format Error Comes up-Is there a solution 2
too many different cells format 1
too many different cell formats 1

Top