When changing cell formats (font, shading, color, size, etc.) on a VERY large
excel file (26 MB), I now receive a dialog popup box saying "Too many
different cell formats". When I persist trying to impose a format change,
the file eventually crashes.

I have been told that Excel has a current limit of 4,000 for various
different cell formts. Can this be increased?

Bob Tripp

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

New limit will be 64k in Excel 12:

http://blogs.msdn.com/excel/archive/2005/9/26.aspx

Regards
Rowan

Bob Tripp wrote:
When changing cell formats (font, shading, color, size, etc.) on a VERY large
excel file (26 MB), I now receive a dialog popup box saying "Too many
different cell formats". When I persist trying to impose a format change,
the file eventually crashes.

I have been told that Excel has a current limit of 4,000 for various
different cell formts. Can this be increased?

Bob Tripp

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc