Format Problem

[Amjad]

I have an excel workbook having 37 sheets full of formulas.Size of the file
is about 7mb. Now I am unable to format anything on anysheet and getting a
message "Too many different cell format"?

Please someone help me.

 

[Norman Jones]

Hi Amjad,

See MS Knowledge Base article # 213904:

'You receive a "Too many different cell formats" error message in Excel'

http://support.microsoft.com/default.aspx?scid=kb;[LN];213904


See also a DeleteUnusedCustomNumberFormats procedure wtitten and posted by
Leo Heuser:

http://tinyurl.com/8rhoq

..(See particularly post # 12 in the above NG thread)