How to use AutoSave in Excel

Article ID: 213943 - View products that this article applies to.
This article was previously published under Q213943
Expand all | Collapse all

On This Page

SUMMARY

This step-by-step article explains how to use the AutoSave feature in Microsoft Excel 97, in Microsoft Excel 2000, and in Microsoft Excel 98 Macintosh Edition.

Excel includes an AutoSave feature that periodically saves your file as you work on it. AutoSave does not save data in a separate file; therefore, the AutoSave feature does not prevent file corruption. However, AutoSave protects your data in the event that Excel unexpectedly quits. When you start Excel, AutoSave is not running by default.

Activate AutoSave

To activate the AutoSave feature, follow these steps:

  1. On the Tools menu, click Add-Ins.
  2. In the Add-Ins dialog box, select the AutoSave Add-in check box, and then click OK.

Modify AutoSave settings

You can modify AutoSave settings, including how often to save, which workbooks to save, and whether to be prompted before saving.

To modify AutoSave, follow these steps:
  1. On the Tools menu, click AutoSave.
  2. In the AutoSave dialog box, select the AutoSave options that you want.
  3. Click OK.
Back to the top | Give Feedback

REFERENCES

For additional information about preventing file corruption, click the following article number to view the article in the Microsoft Knowledge Base:
213951
(http://support.microsoft.com/kb/213951/ )
How to troubleshoot the source of the problem when you save files in Excel 2000 and they become corrupted

Back to the top | Give Feedback

Properties

Article ID: 213943 - Last Review: January 28, 2005 - Revision: 5.1
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbsavefile kbinfo kbhowtomaster KB213943
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top