Format Problem
 

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.

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...5BLN%5D;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)



---
Regards,
Norman



"Amjad" wrote in message
...
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.