How to recover data from damaged workbooks in Excel

Summary

There are several methods that you can use to recover information from damaged or corrupted Microsoft Excel files. This article discusses these methods and includes references to other Microsoft Knowledge Base articles that discuss these methods in more detail. 

Methods for Recovering Data in Corrupted Excel Files

You can use the following methods to troubleshoot problems with opening or using Excel files:
  • Use a recovered copy of the document.
  • Use the Open and Repair command.
  • Save the file in HTML format.
  • Save the file in XML Spreadsheet format.
  • If a chart is linked to the corrupted file, use a macro to extract the data.
Note Detailed steps for each method is listed in "More Information" Section.

More Information

Use a recovered copy of the document
Use the "Open and Repair" command
Save the file in HTML format
Save the file in XML spreadsheet format
Copy worksheets to a new workbook
Use a macro to extract the data in a chart
Properties

Article ID: 820741 - Last Review: Sep 23, 2015 - Revision: 1

Feedback