Wednesday, 15 February 2012

AutoRecover Excel & Word 2007 Document

MS Office 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.

1 comment:

  1. My kids and I always use Microsoft Word for our typing projects. We are actually thankful for autosave function, but sometimes it doesn’t work, especially if someone trips on the plug. Thankfully, the auto-recover system kicks in once we reboot. Though to prevent that one from happing again, we got a UPS, so that we could save our files when there’s a power outage.


    Ruby Badcoe

    ReplyDelete