You are here LEARN EXCEL & VBA Excel Tips Excel General Auto-Recovering/ Auto-Saving a Workbook

Auto-Recovering/ Auto-Saving a Workbook

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
Auto-Recovering/ Auto-Saving a Workbook