Repairing corrupted files in Excel

[Admin]

Applies to
Microsoft Office Excel 2003
Microsoft Excel 2002

Microsoft Excel provides automatic recovery for a corrupted file by attempting to reopen and simultaneously repair the file. Excel identifies what it changed while repairing the file. If the repair fails, Excel again tries to open the file but instead of attempting a repair, Excel extracts cell values and formulas leaving only the data. Under some circumstances, however, Excel won't automatically go into recovery mode, so users may find it necessary to recover file data manually.

To manually repair a file
On the File menu, click Open.
In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
Click Open and Repair, and then choose which method you want to use to recover your workbook.
Methods for recovering data from damaged workbooks
The following are additional methods you can use to recover data manually from a file that has been corrupted. Under some circumstances a disk error or network error may make it impossible to open a file. In those situations you should move your file to a different hard disk drive or from the network to a local disk before spending time implementing the recovery options outlined here.

The following methods are opportunities to save data that might otherwise be lost, so if one method is not successful, try another. You can also try third-party software solutions to recover file data if you can't recover your data using these methods.

If you can open the file in Excel
Use the Revert To Saved Document command

If you are editing a Microsoft Excel worksheet and the file becomes corrupted before you have saved changes to the file, you can recover the original worksheet by doing the following: On the File menu, click Open and select the name of the file that you are editing.
A dialog box appears with the message "Revert to Saved Document?"

Click OK. The file you are editing reverts to the last saved version of the file.
Save the file in SYLK format

Saving the file in SYLK format is typically used to remove printer corruption. If you can open the corrupted Microsoft Excel file, you can "filter" it if you save it in SYLK format, close the file, and then reopen it as follows:

On the File menu, click Save As.
In the Save as type list, click SYLK (Symbolic Link), and then click Save.
Note Only the active sheet in the workbook is saved when you use the SYLK file format. Click OK when the message tells you the selected file type does not support workbooks. Click Yes when the message tells you the file may contain features that aren't compatible with the SYLK format.

On the File menu, click Close.
On the File menu, click Open.
Select the .slk file you saved, and click Open.
Note To see the .slk file, you may need to click All Files in the Files of type list.

On the File menu, click Save As.
In the Save as type box, click Microsoft Excel Workbook, and then click Save.
Note Because this format saves only the active worksheet, you must open the corrupted file repeatedly and save each worksheet separately.

Save the file in Hypertext Markup Language (HTML) format

If you can open the corrupted Microsoft Excel file, you can "filter" it if you save it in HTML format, close the file, and then reopen it as follows: On the File menu, click Save As. In the Save as type list, click Web Page (*.htm, *.html).
Under Save, click Entire Workbook, and then click Save.
Close the file.
Open the file again in Excel.
On the File menu, click Save As. In the Save as type list, click Microsoft Excel Workbook. Change the name of the file to create a new "filtered" copy without replacing the original.
Note Some features may be lost when you save in HTML format.

If you can't open the file in Excel
Set the recalculation option in Excel to manual



_________________
Click the link below to send your corrupt or damaged file for data recovery:
http://www.e-tech.ca/recovery