Saved from a previous post:
XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904
And if you ever have trouble opening this file, you may want to try openOffice.
http://www.openoffice.org, a 60-65 meg download or a CD
A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.
Saum wrote:
I have an Excel file with over 20 different worksheets that link to each
other, and most of their cells are formated. When I was formating one of the
worksheets I received the "Too many different cell formats" error, and from
that point, anytime I try to open the file I receive this same error message.
File recovery is not working, because it removes the formatting, and
formulas. Any suggestions?
Thanks
--
Dave Peterson