Ways to change AutoRecover interval in Office 2007 and 2010?

 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.f 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.

 

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.