Problems oprning Excel File

35 pts.
Microsoft Excel
Microsoft Excel 2003
Microsoft Office
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? Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Many users have
already visited next source-
– that’s why you may look here and check solutions concerning your issue, just

How to Repair a
Damaged Excel File

Manual Repair


the “File” menu. Select the “Open” option.

the Excel file you wish to fix in the window’s main navigation area. Click once
on the file name.

the drop-down arrow located next to the “Open” button. Select the
“Open and Repair” option from this menu. A pop-up window will appear.
Choose the “Repair” option. Excel will attempt to fix any file
corruption issues it finds. If the damaged file is not returned to normal,
repeat the “Open and Repair” process but press the “Extract
Data” button instead of the “Repair” option. This will attempt
to salvage any data stored in the worksheet. If successful, that data will be
saved in a separate file as raw content, without any Excel formatting.

Discuss This Question: 5  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Deblyh
    Hi, I apparently am facing same issue as the user 'EB' but didnt see what is the conclusion from this discussion. May I know what is the solution to that problem for Excel 2003?
    10 pointsBadges:
  • Chippy088
    It is not that big a workbook, I have several over 10mb and do not have a problem because of the size. i am the only person that can access them, so errors in entering data are not a problem. What type of data, and how are you entering it? Are you typing in the data, or importing a csv, or importing from another type of format or application? You don't actually say if this is a shared workbook, or only on your PC. I am thinking it was corrupted in some way, but I don't think it could be because of the way you are adding the data. Do you have any other workbooks that have the same problem? It could even be a fault in the medium you are saving it on. Faulty sectors can cause errors when retrieving files. When was the last time you ran checkdisk?
    4,625 pointsBadges:
  • Koohiisan
    Try opening it with LibreOffice (or, OpenOffice). I've seen times when I could open it there, and resave it as Excel again when the original would crash Excel with similar errors. It's worth a shot to try something free, compared to losing the data, right? :)
    5,045 pointsBadges:
  • sampatrik
    Hi, All above Error message indicate that your excel file is get corrupt. You can repair it with in-build utility of excel that is called "open and repair". In case this utility could not able to fix your problem then use excel repair software to fix your problem.
    265 pointsBadges:
  • timothy12
    Problems with opening excel file must be connected with file corruption.
    In this case I would suggest you repair xlsx file is able to safe for the structure of input documents, safe for confidential data as well
    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: