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
 
Top