How to Move or Copy Excel 2007 Worksheets to Other Workbooks
Comparing Two Excel 2007 Worksheets Side by Side
Specifying Workbook Properties in Excel 2007

Document Recovery in Excel 2007

Excel 2007 offers a document recovery feature that can help you if a computer crashes due to a power failure or some sort of operating system freeze or shutdown. Excel's AutoRecover feature saves your workbooks at regular intervals. In the event of a computer crash, Excel displays a Document Recovery task pane the next time you start Excel after rebooting the computer.

Changing the AutoRecover save interval

When you first start using Excel 2007, the AutoRecover feature is set to automatically save changes to your workbook (provided that the file has already been saved at least once) every ten minutes. You can shorten or lengthen this interval as you see fit. To do so, follow these steps:

  1. Click the Office button and then click the Excel Options button.

    The Excel Options dialog box appears.

  2. Click the Save tab.

    The Save options appear in the right pane.

    Change AutoRecover settings in the Excel Options dialog box.
    Change AutoRecover settings in the Excel Options dialog box.
  3. Use the spinner buttons or enter a new automatic save interval into the Save AutoRecover Information Every xx Minutes text box.

  4. Click OK to close the Excel Options dialog box.

Recovering documents after a system crash

When you open Excel 2007 after a system crash, the Document Recovery task pane shows the available versions of the workbook files that were open at the time of the crash. It identifies the original version of the workbook file and when it was saved along with the recovered version of the file and when it was saved.

Excel 2007 asks you to choose which version of the workbook to open.
Excel 2007 asks you to choose which version of the workbook to open.

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), follow these steps:

  1. Position the mouse pointer over the workbook listed in the Document Recovery task pane.

  2. Click the drop-down menu beside the document name and click Open on the pop-up menu.

  3. (Optional) After you open the recovered version, you can save the workbook.

To save the recovered version of a workbook without bothering to first open it up, follow these steps:

  1. Position the mouse pointer over the workbook listed in the Document Recovery task pane.

  2. Click the drop-down menu beside the document name and click Save As on the pop-up menu.

  3. Save the workbook.

If you want to permanently abandon the recovered version (leaving you with only the data in the original version), click the Close button at the bottom of the Document Recovery task pane. To retain the files for later viewing, select the Yes button before clicking OK. To retain only the original versions of the files shown in the task pane, click the No button instead.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Arranging Windows in Excel 2007 Workbooks
How to Protect an Excel 2007 Workbook
Fixing Broken Formula Links in Excel 2007
Dealing with the New Excel 2007 File Formats
Excel 2010 Data-Entry Etiquette
Advertisement

Inside Dummies.com