too many formats

[Mel]

Could anyone tell me if there's a way of knowing how many
cell formats your workbook is using? I've ran into
the "too many cell formats" error and have cleaned up the
workbook a little and would like to know how many cell
formats I'm currently using to find out whether I should
expect the "too many cell formats" error to return!

 

[Gord Dibben]

Mel

This KB Article addresses this issue.

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

Note: article points out "about 4000" different formats as the limit and makes
suggestions for reducing.

Gord Dibben Excel MVP