Configure the AutoRecover settings in Microsoft Office

[Bradan]

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.

Microsoft Office Excel 2007

1. The controls to configure the AutoRecover feature are in the Save settings in Excel Options.
   
2. Note To open the Save settings, click the Microsoft Office Button, click Excel Options, and then click Save.
   
3. To configure the AutoRecover settings, follow these steps:
   
4. Under Save Workbooks, click to select the Save AutoRecover info every check box to turn on the AutoRecover feature.
   
5. In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.
   
   The default is 10 minutes.
   
   
6. In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.
   
   The default location is as follows:
   drive:\Documents and Settings\user_name\Application Data\Microsoft\Excel
   
   
   • If the location that you type is local (on your hard drive) or is on a network drive, and if this location does not exist, you receive the following error message:
     
     
     

     Cannot access directory path.

     To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
     
     

     100100

   • If you click to clear the AutoRecover file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This will occur until you type a new location.
     
     The AutoRecover file location box remains empty until you type a new location.
7. You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover for this workbook only check box under the AutoRecover exceptions for box. Make sure that the workbook name is selected in the AutoRecover exceptions for box.
   

[Bradan]

Microsoft Office Excel 2003 and earlier versions of Excel

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:

1. Under Settings, click to select the Save AutoRecover info every check box to turn on the AutoRecover feature.
   
2. In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.
   
   The default is 10 minutes.
   
3. In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.
   
   The default location is as follows:
   drive:\Documents and Settings\user_name\Application Data\Microsoft\Excel
   
   Notes
   
   
   • If the location that you type is local (on your hard drive) and if the location does not exist, you receive the following error message:
     
     
     

     Cannot access directory path.

   • If the location that you type is on a network drive, you will not receive an alert until your first AutoRecover attempt. You receive the following error 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 file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This occurs until you type a new location.
     
     The AutoRecover file location box remains empty until you type a new location.
   
   
4. You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover check box under Workbook options.