In Excel 97 and Excel 2000, the Auto Save option operates from the Autosave Add-In. In Excel 2002 and Excel 2003, this option is automatic and the add-in no longer exists.
To enable the Autosave Add-In in Excel 97 and Excel 2000:
1. Install the Autosave Add-In by selecting Add-Ins from the Tools menu, and then selecting the Autosave Add-in checkbox.
2. Click OK.
3. In the Auto Save dialog box, set the Desired Every ... minutes.
To change the default AutoRecovery option (if required):
1. From the Tools menu, select Options, and then select the Save tab (this is a new tab in Excel 2002 and Excel 2003).
2. Change the Save AutoRecover info every: ... minutes, set the Auto Recover save location, and then click OK.
Screenshot // Auto-Recovering/ Auto-Saving a Workbook
You are here