Description of the AutoRecover functions in Excel 2002 and in Excel 2003 (289273)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
This article was previously published under Q289273
Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SUMMARY

Microsoft Excel now has a built-in AutoRecover feature that has replaced the AutoSave add-in that exists in versions of Excel earlier than Microsoft Excel 2002. The AutoRecover feature saves copies of all open Excel files at a user-definable fixed interval. The files can be recovered if Excel closes unexpectedly, for example, during a power failure.

This article contains an overview of the AutoRecover feature.

MORE INFORMATION

Configuring AutoRecover

The controls to configure the AutoRecover dialog box are on the Save tab of the Options dialog box.

Note To open the Options dialog box, click Options on the Tools menu.

To configure the AutoRecover dialog box, follow these steps:
  • Under Settings, click to select the Save AutoRecover info every check box to turn on the AutoRecover feature.
  • In the minutes box, you can type any integer from 1 through 120. The default is 10 minutes.

    This box sets the number of minutes of the save interval.
  • In the AutoRecover save location box, you can type the path and folder name of the location that you want the AutoRecover files to stay.

    The default location is \\Application Data\Microsoft\Excel.

    NOTES
    • If the location you type is a local one (on your hard drive) and it does not exist, you receive the following error message:
      Cannot access directory path.
    • If the location you type is to a network drive, you will not receive an alert until your first AutoRecover attempt. You receive the following message:
      Microsoft cannot save AutoRecover info to path. Please check the network connection or change the location on the Save tab of the Tools, Options dialog.
    • If you clear the AutoRecover save location box but do not enter a new location, AutoRecover files will continue to be saved to the location you cleared until you type a new location. The AutoRecover save location box remains empty until you type a new location.
  • You can turn off the AutoRecover feature in an individual workbook by clicking to select the Disable AutoRecover check box under Workbook options.

When an AutoRecover Event Is Triggered

When an Excel file is open and AutoRecover is turned on, AutoRecover does not save the file until the first change is made to the file, the AutoRecover save time interval passes, and Excel has been idle for some time (the default is 30 seconds). After AutoRecover saves the file, the file is only saved at subsequent save intervals if further changes are made.

When AutoRecover Files Are Deleted

To keep from filling up your AutoRecover location with unneeded files, AutoRecover files are automatically deleted in the following situations:
  • When the file is manually saved.
  • The file is saved with a new file name using Save As.
  • You close the file.
  • You quit Excel, whether you choose to save the file or not.
  • You turn off AutoRecover for the current workbook.
  • You turn off AutoRecover by clearing the Save AutoRecover info every check box.

AutoRecover Save Timing

The AutoRecover timer checks for changed Excel files at the interval you set in the minutes box on the Save tab in the Options dialog box. The timer starts when you start Excel.

When the first save interval passes, Excel checks to see whether any open files have been changed. If Excel locates changed files, an idle timer starts. The purpose of the idle timer is to make sure that the user does not make entries in the worksheet while the save operation occurs. The idle timer restarts each time that the user makes an entry into the worksheet so the AutoRecover save file is not created until both the save interval passes and no entries are made for the duration of the idle time.

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

The default idle time is 30 seconds. To change the default idle time, use the AutoRecoverDelay registry key. To do this:
  1. Quit Excel if it is running.
  2. Click Start, click Run, type regedit in the Open box, and then click OK.
  3. Locate and then select one of the following registry keys.

    For Excel 2002:

    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

    For Microsoft Office Excel 2003:

    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

  4. On the Edit menu, click New, and then click DWORD value.
  5. Type the following name for the new value:

    AutoRecoverDelay

  6. Press ENTER.
  7. Right-click the AutoRecoverDelay registry key, and then click Modify.
  8. In the Value data box, type a number between 1 and 600. This is the number of seconds before AutoRecover tries to save.
  9. When you are finished, click OK.
  10. Quit Registry Editor.
Note Only manually performed actions in the program affect the idle timer. Formulas that automatically update the file do not affect the idle timer. Excel saves the file when the idle time is reached, between the automatic updates to the formulas.

File Formats Saved by AutoRecover

AutoRecover saves all file formats that can be opened in Excel 2002 or in Excel 2003. To maintain speed and simplicity, AutoRecover saves all files as the current Excel file format, regardless of the original file format opened. The file is saved as a hidden file with an arbitrary filename with the extension .xar (for example, ~ar18a.xar).

When you try to save a recovered file upon reopening Excel after it closed unexpectedly, the original file format and name is suggested as the Save file type. Excel stores the original file name and its related .xar file name in the registry for the purpose of recovery.

AutoRecover and Multiple Instances of Excel

When more than one instance of Excel is running and one instance closes unexpectedly, a new instance of Excel is automatically started and the AutoRecover files are opened. If all instances of Excel close unexpectedly, but the computer is still running, a single instance of Excel is started and all AutoRecover files are opened. In the case of a power outage, all recovered files are opened when you start Excel again.

Compatibility

All AutoRecover settings, except the Disable AutoRecover workbook option, are stored in the system registry. AutoRecover settings are compatible with files from previous versions of Excel is not an issue.

When the Disable AutoRecover workbook option is set, and the file is opened in a previous version of Excel, saved, and then reopened in Excel 2002 or in Excel 2003, the Disable AutoRecover workbook option is not affected.

REFERENCES

For more information about Automatic Document Recovery, click Microsoft Excel Help on the Help menu, type autorecover in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

271513 How to troubleshoot errors when you save Excel files

Modification Type:MinorLast Reviewed:1/25/2005
Keywords:kbPubTypeKC kbMSCCSearch kbsavefile kbfunctions kbhowto kbinfo KB289273
©2004 Microsoft Corporation. All rights reserved.