How to repair corrupted excel files

How to repair corrupted excel files

Under some circumstances a disk error or network error may make it impossible to open a file or cause a printer corruption, and you may need to recover an Excel file manually from the file that has been corrupted.

How to repair a file manually

How to save the file in SYLK format and then save it as Excel Workbook

Save the file in Hypertext Markup Language (HTML) format and then save it as excel Workbook

How to repair a file manually

1. On the File menu, click Open.

2. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.

3. Click Open and Repair, and then choose which method you want to use to recover your workbook.

How to save the file in SYLK format and then save it as Excel workbook

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:

1. On the File menu, click Save As.

2. 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.

3. On the File menu, click Close.

4. On the File menu, click Open.

5. 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.

6. On the File menu, click Save As.

7. 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 and then save it as excel Workbook

1. On the File menu, click Save As. In the Save as type list, click Web Page (*.htm, *.html).

2. Under Save, click Entire Workbook, and then click Save.

3. Close the file.

4. Open the file again in Excel.

5. 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.

Post your questions, comments, feedbacks and suggestions

Contact a consultant