Page 41 - Excel Timesaving Techniques for Dummies

05_574272 ch04.qxd 10/1/04 10:25 PM Page 26
26
Technique 4: Saving Your Worksheets So You Can Find Them
the backup file for you and enables you to com- to see how much of the data was recovered. If you
pare the recovered file to the original and, if you decide that you want to retain the recovered version
so desire, replace the original with the recovered of the file and replace the original version, choose
version. File➪Save and choose Yes in the alert dialog box
5. Click OK to close the Options dialog box and that warns you that you’re about to replace the
put your new settings into effect. existing file.
If you know that you want to replace the origi-
Select the Disable AutoRecover check box on nal with the recovered version, you don’t have
the Save tab of the Options dialog box at your to bother with opening the recovered file. Just
own peril. In disabling this feature, you run the click the drop-down button for the file marked
risk of losing all your data should you have a [Recovered] and select Save As on the pop-up
software or hardware mishap before you take menu. If you don’t want to replace the original,
the time to manually save the file.
be sure to enter a new filename in the Save As
dialog box.
If your software freezes up or your computer
crashes when the AutoRecover feature is enabled In the odd event that you want to discard the recov-
and in use during a work session, the next time you
ered version and retain only the original (and pre-
launch Excel, the program displays the Document sumably less complete) version of the file, simply
Recovery task pane. This pane identifies both the
click the Close button in Document Recovery task
original and recovered versions of the workbook file. pane and then select the No (Remove These Files. I
You can open the recovered version (by clicking its
Have Saved the Files I Need) option button in the
button and then selecting Open on its pop-up menu)
alert dialog box that appears.