"Too many formats used"!!!

[Guest]

I have a large spreadsheet with multiple input forms which is almost complete. I am unable to progress further as Excel will not allow me to format any more cells with a "Too many formats used" message being displayed

I understand that I need to reduce the amount of formatting that has been used, but my endeavours to do so simply pops up the same message.

Is there a simple way to reduce the number of formats used in a spreadsheet either globally or per worksheet? Or any other solutions to this problem

Any help would be greatfully appreciated.

 

[Frank Kabel]

Hi
for dealing with too many cell formats have a look at the following KB
article
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

 

[Debra Dalgleish]

The following post by Dave Peterson has some information that may help
you with the reformatting:

http://groups.google.com/groups?&[email protected]