Problems oprning Excel File

35 pts.
Tags:
Excel 2003
Microsoft Excel
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
ASKED: May 1, 2008  8:53 PM
UPDATED: December 29, 2011  3:44 AM

Answer Wiki

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

Please let me know exatly how many sheets and approximately the rows and columns in each sheet that you are using.

Sometimes the file size shoots up due to a Macro or virus. Tell me the above and will let you know further how to go about.

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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:
    report
  • 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:
    report
  • 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,020 pointsBadges:
    report
  • 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:
    report
  • timothy12
    Problems with opening excel file must be connected with file corruption.
    In this case I would suggest you repair xlsx file  
    http://www.repairxlsx.xlsxrepairtoolbox.com is able to safe for the structure of input documents, safe for confidential data as well
    10 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following