How to Repair a Damaged Excel File
Excel worksheets can get corrupt or damaged at any point of time. Just imagine
working on important financial figures and power goes off. And when power comes
back, you cannot access your worksheet or the excel file fails to open. Now what to do?
There are times when MS Office application automatically recovers the unexpected
closed document with the help of Auto recover option and your data is saved from
being lost and inaccessible. But what happens when you cannot access your data,
can you still get it back. The answer is "Yes". Why not?
The fast paced technology has developed such recovery tools to recover and
restore the lost data. If you lose your data, you can still get it back by
performing some basic steps or at last if their remains no hope, you can select
a third party utility - an excel file repair software. This article aims to
discuss those methods and points which prove helpful in the cases when you lose
your important data.
How Data Becomes Corrupt or Inaccessible:
Before discussing the preventions first we should look at some of the causes due
to which the excel file gets corrupt. The causes are:
- Virus Attacks
- Unexpected or improper system shutdown
- Power Outages
- Media Errors
- Error messages like:
"Excel unable to read file..",
"This file is not in a recognizable format", "????.xls file cannot be accessed.
The file may be read-only", "Excel.exe has generated errors and will be closed by
Windows. You will need to restart the program; an error log is being created".
Methods to Recover Data from the Corrupt Excel Files:
- Saving the file in HTML format
- Use of Revert To Saved Document feature
- Open file in MS Word
- Open file in MS Excel Viewer
- Disable Macros
- Use of External Link Formulas in another Worksheet
- Use of Excel's built-in Detect and Repair feature
- Other Procedures
1. Saving the file in HTML format
If you are unable to access data or open the worksheet, then you can save the
corrupt file in .html format and then reopen it. To do this, perform the
- Click the File menu > click the Save As option.
- Click the Save as type > list, select the Web Page (*.htm, *.html) option.
- Close the file
- Again open the file in MS Excel
- Click the File menu, and select the Save As option.
- Click the Save As type list and select the Microsoft Excel Workbook option. Change the name of the file, to create filtered copy without replacing the original worksheet file.
Note: Some features might get lost when the file is saved in HTML format.