Microsoft Office Tutorials and References
In Depth Information
Document Recovery to the Rescue
When you first start using Excel 2013, the AutoRecover feature is set to
automatically save changes to your workbook (provided that the file has already
been saved) every ten minutes. You can shorten or lengthen this interval as
you see fit. Choose File Options Save or press Alt+FTS to open the Excel
Options dialog box with the Save tab selected. Use the spinner buttons or
enter a new automatic save interval into the text box marked Save
AutoRecover Information Every 10 Minutes before clicking OK.
After re-launching Excel 2013 after a computer crash that prevents you from
saving your workbook file, the program opens with the Document Recovery
task pane on the left side of the screen. This Document Recovery task pane
shows the available versions of the workbook files that were open at the time
of the computer crash. The original version of the workbook file is identified,
including when it was saved, as is the recovered version of the file (display-
ing an .xlsb file extension) and when it was saved.
To open the recovered version of a workbook (to see how much of the work
it contains that was unsaved at the time of the crash), position the mouse
pointer over the AutoRecover version, click its drop-down menu button
followed by Open. After you open the recovered version, you can then (if you
choose) save its changes by selecting the Save button on the Quick Access
toolbar or by choosing File Save.
To save the recovered version of a workbook without bothering to first open
it, click the recovered version’s drop-down button in the Document Recovery
task pane, and then choose Save As. To abandon the recovered version
permanently (leaving you with only the data in the original version), click
the Close button at the bottom of the Document Recovery task pane. When
you do this, an alert dialog box appears, giving you the chance to retain the
recovered versions of the file for later viewing. To retain the files for later
viewing, select the Yes (I Want to View These Files Later) radio button before
clicking OK. To retain only the original versions of the files shown in the task
pane, select the No (Remove These Files. I Have Saved the Files I Need) radio
button instead.
The AutoRecover feature only works on Excel workbooks that you’ve saved
at least one time (as explained in the earlier section “Making Sure That the
Data Is Safe and Sound”). In other words, if you build a new workbook and
don’t bother to save and rename it prior to experiencing a computer crash,
the AutoRecover feature will not bring back any part of it. For this reason, it is
very important that you get into the habit of saving new workbooks with the
Save button on the Quick Access toolbar very shortly after beginning to work
on worksheets. Or use the trusty keyboard shortcut Ctrl+S.
Search JabSto ::

Custom Search