Repair a Corrupted Workbook File Excel

If you have an Excel workbook that you can no longer open because the file has become corrupted, Excel offers a repair option that should enable you to fix the file. Excel workbooks rarely have problems and they generally open successfully. However, a hard disk error or memory error could create a problem that corrupts the file.
When that happens and you try to open the workbook, Excel displays an error message telling you either that it does not recognize the file format or that the file is corrupted. Whatever the cause, it is important that you do not lose any data, so Excel offers an Open and Repair command that first attempts to repair the file, and then to open the repaired workbook in Excel.

Excel Menu

1. Click the File tab.
2. Click Open. 
The Open dialog box appears.
3. Click the workbook you want to repair.
4. Click the Open drop-down list.

5. Click Open and Repair.

6. In the dialog box that appears, click Repair.

7. Excel repairs and then opens the file.

More Options!

 If Excel cannot repair the workbook, you may still be able to save the workbook’s data. Follow steps 1 to 5 to select the Open and Repair command. In the dialog box that appears, click Extract Data. In the dialog box that appears, click Recover Formulas if you want Excel to try and recover the workbook’s formulas. If that does not work, repeat Steps 1 to 5, click Extract Data, and then click Convert to Values, instead; this tells Excel to convert all the formulas to their results. After Excel repairs the file, click Close.

Another option you have to recover some or all of your work is to open a previous version of the workbook, if one exists. Follow steps 1 to 4 to display the Open drop-down list, and then click Show Previous Versions. Excel displays a list of the available versions of the workbook. Click the version you want to use — usually the most recent version that you believe is not corrupted — and then click Open.

Categories: Excel 2010