Problem Opening excel Workbook

Hello There,

I am using MS Excel 2003 with XP Home SP2 and have been working with an Excel 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; 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 eventually gets to the point where this error window comes up and the problem resurfaces.

Could it be that the workbook has too much data? The file size is only 3.54MB. My PC has 504 MB RAM and 51 GB free HD space.

Can anyone give me some help with this problem?

Thanks

i am also facing the same problem as yours.

i have to create reports based on my saved forms in excel. i open my report forms and save them with new names after filling in the data. but from last few days i am loosing some 10-20 percent of files due to this problem. If somebody can help.

there is no file available in autorecover folder.
I am using Office 2007

Please help

i have a client with the same issue. except they can't open it at all.

the file opens with no issues on 4 other pc's in the company.

we run xp pro sp2 with office 2003

ran the file through multiple excel file repair programs but they all state there are no issues.

i have got it to open by doing the following.....

1. open the file on a known good pc that doesn't give the error.
2. the file contains multiple error's of only this single message "number stored as text."
3. I type the number 1 in any empty cell below all the data>then copy the cell>then select all the remaining data in the worksheet>do a edit->paste special> and then check off Multiply
4. this cleared all errors on the excel document
5.did a save as with same filename but in a new location
6. sent it to the client and they can now open the document on any pc.


this may help you out..

im just still trying to figure out why a small "number as text" error would stop it from opening only on certain pc's.