Microsoft Office Tutorials and References
In Depth Information
Recovering from crashes
Recovering from crashes
In the past, crash recovery largely involved an initial flurry of expletives followed by a brisk
walk around the office and perhaps a couple of aspirin. Excel 2013 provides something
beyond comfort and sympathy for digital mishaps—an actual mechanism that attempts to
tuck away open files before the program comes screeching to a halt. And it works pretty
well. If Excel encounters a problem, it attempts to save any files that are open at the time
the problem occurs, before bad things happen to them when the program crashes and
burns.
Understanding AutoRecover
Over the years, Excel has greatly improved its ability to recover lost work after a crash. By
default, all unsaved workbooks are backed up automatically every 10 minutes, storing what
Excel calls AutoRecover information. This is not the same as saving your workbook, because
Excel stores AutoRecover information in a different place with a cryptic file name. You
might lose a few minutes worth of work, but you can change the time interval anywhere
from 1 to 120 minutes. If Excel or your system crashes, the AutoRecover feature presents
a list of rescued versions of all files that were open when the crash occurred the next time
you start Excel.
To change settings or turn off AutoRecover, click the File tab, select Options, and select the
Save category to display the dialog box shown in Figure 2-41.
AutoRecover File Location is set to a subfolder buried deep in your hard disk—this is OK
because you should save the real files elsewhere rather than cluttering up your working
directories with recovery files. If you want, you can easily change the location. You can also
choose to disable AutoRecover for specific workbooks without having to turn it off and on
manually. You can use the AutoRecover Exceptions For area in the dialog box to do this.
Just select a workbook in which you want to disable AutoRecover from the drop-down list
displaying all the currently open workbooks, and select the Disable AutoRecover For This
Workbook Only check box. You can do this separately for any open workbook.
Search JabSto ::




Custom Search