Is there a way to check the number of different cell formats?

C

Clay2007

I am developing a large workbook with dozen of worksheets and I had it crash
recently because I exceeded 4,000 different combinations of cell formats. I
found Article #213904 on line that discusses the error message and explains
the reason for the crash. I found the article only somewhat helpful because
it doesn’t say how I can monitor the number of formats as a rebuild the
spreadsheet. Anyone have any ideas?

Much Thanks
 
J

Jan Karel Pieterse

Hi Clay2007,
I found the article only somewhat helpful because
it doesn’t say how I can monitor the number of formats as a rebuild the
spreadsheet. Anyone have any ideas?
Click to expand...

The best way to keep a lid on cell formats is by using styles and doing so
rigorously. This forces you do consider carefully what different formatting
combinations you truly need and also streamlines the appearance of your file.
And this way greatly reduces the number of combinations.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 

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 DIFFRENT CELL FORMATS 0
What causes the "Too many different cell formats" error in Excel 2
Too many different cell formats error message in Excel 5
Limitations on the number of formats used in a workbook 1
Will excel 2007 support more than 4,000 cell formats? 9
Is there an easy way to see all employees absences on a calendar? 0
Too Many Different Cell Formats 1
"Too many different cell formats" in Excel 0

Top