I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below:
[Excel found unreadable content in 'filename.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes]
When I click yes I get another error window with the message shown in bold font below:
[Errors were detected in 'filename.xls,' but Microsoft Office Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.]
[Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.]
When I close this second error window, the workbook opens with all the formulas and data correct, but all the formatting with color, dates and percentages are lost.
If I start over with a blank workbook, enter each month's data and open the file at intervals it will work fine. However, as I continue adding data, it becomes unstable and eventually gets to the point where it returns this error window.
Could it be that the workbook has too much data? The file size is 3.54MB
Does anyone give me some guidance with this problem?