Change AutoRecover interval in Office 2007 and 2010

Among the many useful features of the Microsoft Office 2007 applications is AutoRecover.  It involves saving all the data in the Office 2007 application after a specific time interval so that it is recovered in case there is a power outage or a system crash. All your work or data in the Office application is saved automatically after that specific time interval. This feature keeps you from losing work you have done. By default, this AutoRecover interval is set to 10 minutes in all the Office 2007 applications. However, it is possible to change AutoRecover interval in Office 2007.  If you change AutoRecover interval in Office 2007 to less than 10 minutes such as after every 5 minutes, you will be able to save your work or data frequently. It will prove very helpful if you are facing problems in the power supply or your operating system.

The option to change AutoRecover interval in Office 2007is offered for every application. Here we will use the example of Excel 2007. Follow these steps to change AutoRecover interval in Office 2007:

1.     Click on the Office button.

2.     Click on the "Excel Options"  button on  the bottom of the resulting menu

.3.     The Excel Options dialog box will appear. Select Save on the left hand side of the menu

.4.      Check the box for "Save AutoRecover information"     .5.  Select how often you would like Excel to save the data for AutoRecover. 

 

6.     Click OK.

 

You should not set the time to a very short time interval. Remember that when working on larger worksheets or documents don't set the AutoRecover to a very short time interval such as 1 minute because that may begin to slow down the computer, as saving a large amount of data after each minute will strain the computer.