Computer Tips # 65 : How to change the retention period for Autorecover in Microsoft Office 2007 and Office 2010?

In Microsoft Office 2007, you have many useful features. One of them is Autorecover. This feature is related to the program to save all the data in Office 2007. It is used after the recovery due to power failure or system crash. all of your data or work in the Office application is saved automatically after the retention period. This Featureallows you to maintain your loss. By default, this AutoRecover interval is set to 10 minutes in all the Office 2007 applications. However, you can change the Autorecover interval in Office 2007. For example. If you change Autorecover Interval is 5 minutes, it willbe very helpful. Because you risk your data will be dropped.

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 a time in a very short time. Remember that when you work on a large Worksheet and set a very short time interval such as 1 minute, this will cause your machine to slowdown because of the need to save every minute.