Save Error - How to repair

[JC]

I have a file that I am trying to save. Everytime I
select Save I get the following message:

Excel could not save all the data and formatting you
recently added to file data file.xls.
-To return to your workbook without saving click Cancel.
-If you want to continue saving changes without repairing
the problem, click OK.
-For information about repairing the problem, click Help.

When I click Help I get a blank grey box. How can I find
out what is wrong?

Thanks,
JC

 

[Dave Peterson]

It kind of sounds like you're getting hit with the fact that Excel has a limit
of 4000 different formats in a workbook.

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/?scid=213904

Sometimes this pops up when you're opening a workbook. I've seen posts that say
some people have used OpenOffice to open, reformat, save and not lose their
data.

(http://www.openoffice.org, a 60-65 meg download or a CD)

(Can you format entirecolumns and entirerows instead of cell by cell??)