Microsoft Office Tutorials and References
In Depth Information
Disaster Recovery
Saving Files
Figure 14-24:
You can configure
how often
AutoRecover saves backups.
There’s really no
danger in being too
frequent. Unless you
work with extremely
complex or large
spreadsheets—which
might suck up a lot
of computing power
and take a long time
to save—you can
set Excel to save the
document every five
minutes with no
appreciable slowdown.
• You can control whether Excel keeps a backup if you create a new spreadsheet,
work on it for at least 10 minutes, and then close it without saving your work.
This sort of AutoRecover backup is called a draft . Ordinarily, the setting “Keep
the last Auto Recovered file if I exit without saving” is switched on, and
Excel keeps drafts. (To find all the drafts that Excel has saved for you, choose
File Recent and click the Recover Unsaved Workbooks link at the bottom of
the window.)
• You can choose the folder where you’d like Excel to save backup files. The
standard folder works fine for most people, but feel free to pick some other place.
Unfortunately, there’s no handy Browse button to help you find the folder, so
you need to find the folder you want in advance (using a tool like Windows
Explorer), write it down somewhere, and then copy the full folder path into this
dialog box.
• Under the “AutoRecover exceptions” heading, you can tell Excel not to bother
saving a backup of a specific spreadsheet. Pick the spreadsheet name from the
list (which shows all the currently open spreadsheet files), and then turn on the
“Disable AutoRecover for this workbook only” setting. This setting is
exceedingly uncommon, but you might use it if you have a gargantuan spreadsheet full
of data that doesn’t need to be backed up. For example, this spreadsheet might
hold records that you’ve pulled out of a central database so you can take a closer
look. In this case, there’s no need to create a backup because your spreadsheet
just has a copy of the data that’s in the database.
Search JabSto ::




Custom Search