Microsoft Office Tutorials and References
In Depth Information
Recovering corrupted files
Figure 2-33 shows the Open dialog box, where you can find the Open Options menu (click
the arrow next to the Open button) containing the Open And Repair command. This
command gives you a fighting chance at either repairing a corrupted file or extracting the data
from it if it doesn’t respond to a repair attempt. When you select a file and click the Open
And Repair command, the message box shown in Figure 2-34 opens.
Figure 2-34 The Open And Repair command gives you a ray of hope for recovering lost data.
Try the Repair button first, and if Excel still has no luck opening the file, try the Extract Data
button, which displays the message box shown in Figure 2-35.
Figure 2-35 The Extract Data button offers two ways to recover your data.
You’ll have to make a judgment call here—if you think your formulas will be OK after
extraction, click Recover Formulas; otherwise, click Convert To Values. Recovering formulas
will probably work unless the formulas include references to cells that were lost in
corruption. Whatever you select, the Extract Data feature pulls all the data from your workbook,
including all worksheets and tabs, in the same order in which they appear in the original
file. Unfortunately, the recovery process ignores all formatting, charts, and other objects—
you can recover only the actual cell contents (the important stuff).
Note that unless the part of the file that became corrupted was the part storing
passwords, you probably won’t be able to use this technique to retrieve data from a