How do I eliminate, in Excel XP, "too many cell formats" error?



In workbook, which I 'Save As' from month-to-month for my monthly financials,
I have been getting "too many cell formats" This is in Excel within Office



Nick Hodge

This is quite a common error as Excel allows a relatively small amount of
formats and a format is counted if it differs in any way from another, two
cells with exactly the same except on a point bigger is counted as a
separate format.

You will need to audit the sheet and cut them back or better still, set up
some styles (Format>Styles...) and apply these. That way they will all be
guaranteed the same

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