Microsoft Office Tutorials and References
In Depth Information
Repair a Corrupted Workbook File
Chapter 2: Making It Easier to Manage Workbooks
5 Click Open and Repair.
6 In the dialog box that
appears, click Repair.
Excel repairs and then
opens the file.
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.