Too many different cell formats?

[jimharsh]

Just got this error message on a large file that I am working on in Excel 2010 when I tried to format a block of cells. Any ideas as to how to fix?

 

[JLGWhiz]

Just got this error message on a large file that I am working on in Excel 2010 when I tried to format a block of cells. Any ideas as to how to fix?

Unless one can figure out how to make a blivet out of the worksheet, these are the limits. the only remedy is to reduce the formats to within limits.

Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed

<TBODY>
</TBODY>