Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 File Management and Recovery

Change AutoRecover Save Frequency

Summary: Save Microsoft Excel 2003 AutoRecover files more or less often.

To help protect you from losing spreadsheet changes due to a power outage or software bug, Microsoft Excel 2003 automatically saves a copy of open spreadsheets every 10 minutes if you forget to save the spreadsheets yourself. This way, if the system or software crashes and is restarted, the unsaved documents are automatically reopened, lessening the chance of lost data.

If up to ten minutes of changes is too long to lose in case of a problem causing Excel 2003 to close unexpectedly, you can change this setting and have Excel 2003 save AutoRecover files more often. Note that when Excel 2003 does an AutoRecover save, it will take control of the spreadsheet and not allow changes to occur for a few seconds. Thus, some people would rather wait a little while longer between AutoRecovers.

To tweak this setting:

1. Click "Tools" - "Options".

2. When the "Options" multi-tabbed dialog box appears, click the "Save" tab.

3. Next to "Save AutoRecover info every", enter in the amount of minutes that should pass between saving AutoRecover files.

4. Click "OK" to close the dialog box.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 3:23 P.M. EDT

Return to the Microsoft Excel 2003 File Management and Recovery page.

Print this tip.

- Subscribe!

Search the Site: