Microsoft KB Archive/147778

= XL: How to Enable AutoSave =

PSS ID Number: 147778

Article Last Modified on 8/19/2003

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows
 * Microsoft Excel for Windows 95 7.0
 * Microsoft Excel for Windows 5.0
 * Microsoft Excel 98 Macintosh Edition

-



This article was previously published under Q147778





SUMMARY
Microsoft Excel includes an AutoSave feature that periodically saves your file as you work on it. AutoSave does not save data into a separate file; therefore, the AutoSave feature does not prevent file corruption. However, AutoSave protects your data in the event that Microsoft Excel unexpectedly quits.



MORE INFORMATION
When you start Microsoft Excel, AutoSave is not running by default. To start AutoSave, use the following procedure that is appropriate for your version of Microsoft Excel.

Microsoft Excel version 7.0, or Microsoft Excel version 5.0
To make AutoSave available, follow these steps:


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

You can modify AutoSave settings, including how often to save, which workbooks to save, and whether to be prompted before saving. To do this, on the Tools menu, click AutoSave, and select the options you want in the AutoSave dialog box.

Microsoft Excel version 4.0 for the Macintosh
To make AutoSave available, follow these steps:


 * 1) On the Options menu, click Add-Ins.
 * 2) In the Add-Ins dialog box, click the Add button.
 * 3) In the dialog box that appears, click the Macro Library folder, select the AutoSave macro in that folder, and then click the Open button.
 * 4) In the Add-in Manager dialog box, click Close.

To modify the AutoSave default settings, on the Options menu, click AutoSave, and then select the options you want.

Microsoft Excel version 4.0 for Windows
To make AutoSave available, follow these steps:


 * 1) On the Options menu, click Add-ins.
 * 2) In the Add-Ins dialog box, click Add.
 * 3) In the dialog box that appears, select the Library folder, select Autosave.xla in that folder, and click OK.
 * 4) In the Add-in Manager dialog box, click Close.

To modify the AutoSave default settings, on the Options menu, click AutoSave, and then select the options you want.

Microsoft Excel version 3.0 for the Macintosh
To make AutoSave available, follow these steps:


 * 1) Copy the Auto Save macro from the "Macro Library" folder to the "Excel Startup Folder" folder (located in the "System Folder: Preferences" folder).
 * 2) Restart Microsoft Excel.

To modify the AutoSave default settings, on the Options menu, click AutoSave, and then select the options you want.

If you are using Microsoft Excel version 3.0 for Windows
To make AutoSave available, follow these steps:


 * 1) Copy the Autosave.xla file from the Library folder to the XLStart folder.
 * 2) Restart Microsoft Excel.

To modify the AutoSave default settings, on the Options menu, click AutoSave, and then select the options you want.

NOTE: Use care when you set the duration between saves. For instance, if you set the duration between saves to one minute, when you edit a large file, you may inadvertently lock up Microsoft Excel because it will continually save the file.

For additional information about preventing file corruption, please see the following article in the Microsoft Knowledge Base:

149235 : Excel: How to Prevent File Corruption

Additional query words: 8.00 98 XL98 XL97 XL7 XL5 XL4 XL3 back up backup lose

Keywords: kbinfo KB147778

Technology: kbExcel500 kbExcel95 kbExcel95Search kbExcel97Search kbExcel98 kbExcel98Search kbExcelMacsearch kbExcelSearch kbExcelWinSearch kbHWMAC kbOSMAC kbZNotKeyword3

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.