How to Repair a corrupted workbook

I am continuing with Computer Help for Excel Application. It post help to repair corrupted file in Excel. When you open a workbook that has been corrupted, Microsoft Office Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.

Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually.

You can also try other methods to recover workbook data when repairing a workbook is not successful. As a preventive measure, you may want to save your workbook often and create a backup copy every time that you save it. Or you can specify that Excel automatically creates a recovery file at specific intervals. This way, you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted.

Repair a corrupted workbook manually

1. Click the Microsoft Office Button , and then click Open.
2. In the Open dialog box, select the corrupted workbook that you want to open.
3. Click the arrow next to the Open button, and then click Open and Repair.
4. 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.