Too Many Cell Format Error Comes up-Is there a solution

[Sue]

I have a large spreadsheet and I when I tried to Format a new cell I am
getting the error message Too Many Cell Formats and it won't let format any
more cells. Is there a work around for this?

 

[Dave F]

There's a built in limit to the amount of different formats that can be
applied in a spreadsheet.

The workaround would be to split the spreadsheet into two different
workbooks or to use Excel 2007 beta, which has significantly increased the
number of different cell formats that can be handled in a single workbook.

Dave

 

[Stephane Rodriguez]

Yes, there is a solution.

http://office.microsoft.com/en-us/marketplace/EM101938821033.aspx


And directly here :

http://xlsgenreduction.arstdesign.com/