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.

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.

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.