This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 File Management and Recovery - Change AutoRecover Save Frequency

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 File Management and Recovery - Change AutoRecover Save Frequency.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.