Microsoft Office Tutorials and References
In Depth Information
If your computer crashes in mid-edit, the next time you open Excel you’ll probably
see the same file listed twice in the Document Recovery window, as shown in Figure
14-23. The difference is the status. The status [AutoSaved] indicates the most recent
backup created by Excel. The status [Original] indicates the last version of the file
that you saved (which is safely stored on your hard drive, right where you expect it).
You can save or
open an AutoRecover
backup just as you
would an ordinary
Excel file; simply click
the item in the list.
Once you’ve dealt
with all the backup
files, close the
window by clicking
the Close button. If
you haven’t saved
your backup, Excel
asks you at this point
whether you want to
save it permanently
or delete the backup.
To open a file that’s in the Document Recovery window, just click it. You can also use
a drop-down menu with additional options (Figure 14-23). Make sure you save the
file before you leave Excel. After all, it’s just a temporary backup.
If you attempt to open a backup file that’s somehow been scrambled (technically
known as corrupted ), Excel automatically attempts to repair it. You can choose Show
Repairs to display a list of any changes Excel had to make to recover the file.
AutoRecover comes switched on when you install Excel, but you can tweak its
settings. Choose File ➝ Options, and then choose the Save section. Under the “Save
workbooks” section, make sure that “Save AutoRecover information” is turned on.
You can also make a few other changes to AutoRecover settings:
• You can adjust the backup frequency in minutes. (See Figure 14-24 for tips