Excel was able to open the file by repairing or removing the unreadable content.

[soxlug]

This has happened a couple of times where I open a locally stored spreadsheet and get a warning that reads:

Excel was able to open the file by repairing or removing the unreadable content.

Removed records: shared formula from /xl/worksheets/sheet3.xml part
Removed records: formula from /xl/calcChain.xml part (calculation properties)

click to view log file listing repairs: "local path to an xml file"

the xml file then basically shows the removed records that are shown above. I am not sure what is causing this issue has anyone seen this and have an idea as to why this warning appears.

 

[bwcpa]

If you click to repair the file, it will delete whatever it thought was corrupt. In my case, it was an entire sheet. Fortunately, I didn't need the data on that sheet any longer. However, I did go into an older version of the same spreadsheet and found the sheet that had the error. I broke all links to that sheet. I will be keeping an eye out for any other links that may appear in other spreadsheets I use and break the links if they aren't needed since this seems to cause confusion in Excel for some reason.

Also, after reparing the file, Excel gives you the worksheet that contained the error. You can figure out which worksheet it is referring to by right clicking on a worksheet tab and choosing View Code. On the left, there will be a list of all of your worksheet tabs with the name you've given them and Excel's original name (i.e. Worksheet26). The Excel message gives you the original Excel name.

I hope Microsoft can fix this in their next version - what a pain!

 

[abbasfattah]

Repair a corrupted workbook manually


Click the Microsoft Office Button , and then click Open.

1. In the Open dialog box, select the corrupted workbook that you want to open.
2. Click the arrow next to the Open button, and then click Open and Repair.
3. Do one of the following:
   • To recover as much of the workbook data as possible, click Repair.
   • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

If this method wasn’t effective in your case, apply Excel Repair Toolbox offered here are highly advanced and have strong built in data recovery algorithm that can produce desired results. By using this user can perform quick and accurate recovery of corrupt .XLS and .XLSX files.

Features of Excel Recovery Software-

§ Recovers all types of Excel data with full accuracy.
§ Recovers multiple .XLS and .XLSX files.
§ Maintains data integrity of the original file after repairing the damaged Excel sheets.

Visit:- http://www.excelrepairtoolbox.com/

 

[JamesNorinton]

My advice to you, try to install some recovery tool, for example free demo of recovery tooIbox for Excel. Full program is not free, but demo is enough for your problem, I suppose. You can download it here: [url]http://www.repairexcel.recoverytoolbox.com/ [/URL] If it doesn’t help read this topic. There is some more ways to recover your .xls file. How to repair and recover corrupt MS excel file?

 

[dougall]

This software is more result-oriented and specially designed for recover and repair corrupt, damage, or virus affected excel files. It is also supports to recover corrupt, damage password protected excel files. For more details visit here : - Excel File Recovery Tool to Repair Corrupt or Damaged Excel Files(.xls & .xlsx)

 

[9tanstaafl9]

In case anyone else has this problem in the future, I wanted to post one other possible cause for this error. It can be caused if a parameter set for an external connection refers to a field that no longer exists. In my case, I had deleted a sheet that an external query on another sheet was using. I had no idea that this other external connection even existed as this was a workbook created by someone else. The error message and log file that I saw during the repair did not mention the query by name or the sheet it was on. I only discovered that this was the problem through trial and error. Easy fix: In the menu, select Data, then Connections, then for each connection choose Properties, then Definition. On the definition window, if the Parameter button is enabled, click on that and verify that the parameter location still exists. Fixing this got rid of my issue. Note that this only works if you have an older, pre error version of the workbook.