Auto-Recovering/ Auto-Saving a Workbook

My Account

Check out

Shopping Cart

JOIN OUR NEWSLETTER
and receive for joining:
	Free eBook Learn More!
	Free Excel ADD-IN
	Free Weekly Excel Tip








F1 eBook (Spanish)

» Auto-Recovering/ Auto-Saving a Workbook

CATEGORY: Excel Worksheet, Workbook

VERSIONS: All Microsoft Excel Versions

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

Rate this tip



1	2	3	4	5

RATING: 3.69
VIEWS: 26382

Email Tip

Print Tip

Add to My Tips

READER COMMENTS (view all comments)

Reg.
Anitha M wrote on December 31, 1969 18:00 EST

I was looking out as to how to autosave in excel from past 1 month or so, & could not find an answer. Atlast this website has been great, in just 2 minutes, even less I could know how to autosave in excel.

This is great, keep the good work going & make life simple!

Thank you,

Anitha

good one!
P wrote on December 31, 1969 18:00 EST

goof tip.had my answer in seconds on the web...via google

Erm, but hang on...
Mr B. wrote on December 31, 1969 18:00 EST

The autosave seems ok, but does not protect against the accidental "user failure" of people pressing, no don't save my changes. (we've *all* done it before by accident)

I seem to recall the plugin versions simply "overwrite" saved the file every n time periods, protecting the users from their own issues.

Effectively the 2002 / 3 variation only protects from a crash / power failure condition, so users will still need to press the floppy icon occasionally as a workaround.

losing hyperlinks
brendan wrote on December 31, 1969 18:00 EST

i create hyperlinks to navigate through my work books but for some reason over time they seem to stop functioning dose any one know how to make them a permenant part of my work book

Guide to Financial Reporting and Analysis

Retire Young, Retire Rich

Infectious Greed: How Deceit and Risk Corrupted the Financial Markets

Special Edition Using Microsoft Excel 2002

Accounting Principles, with CD, 6th Edition

The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve

RELATED MICROSOFT EXCEL TIPS

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

	Advertise With Us
Tips	Add-In in VBA \| Applications - Word, Outlook in VBA \| Array Formulas \| Cells, Ranges, Rows, and Columns in VBA \| Counting \| Custom Functions \| Custom Functions in VBA \| Database Formulas \| Database in VBA \| Date & Time Formulas \| Date & Time in VBA \| Events in VBA \| Excel 2003 \| Excel Chart \| Excel Consolidating \| Excel Counting \| Excel Custom Functions using VBA \| Excel Customizing \| Excel Data \| Excel Dates \| Excel Editing \| Excel Files \| Excel Filter \| Excel Format \| Excel Formula \| Excel General \| Excel Grouping and Outlining \| Excel Importing Text Files \| Excel Information \| Excel Keyboard Shortcuts \| Excel Loan Formulas \| Excel Macros - VBA \| Excel Pivot Tables \| Excel Printing \| Excel Range Name \| Excel Security - Protection \| Excel Sorting \| Excel Style \| Excel Subtotals \| Excel Summing \| Excel Text \| Excel Time \| Excel Tools \| Excel Worksheet, Workbook \| Files, Workbook, and Worksheets in VBA \| Financial Formulas \| Formating in VBA \| General Topics in VBA \| Import and Export in VBA \| Information Formulas \| Keyboard & Other Shortcuts in VBA \| Keyboard Formula Shortcuts \| Links between Worksheet and Workbooks \| Links in VBA \| Logical Formulas \| Lookup Formulas \| Mail - Send and Receive in VBA \| Menus, Toolbars, Status bar in VBA \| Modules, Class Modules in VBA \| Other Q&A Formulas \| Printing in VBA \| Protecting in VBA \| Summing \| Text Formulas \| User Forms, Input boxes in VBA \| Using Loops \| Working with Formulas \|
Tips by Version	Microsoft Excel 97 \| Microsoft Excel 2000 \| Microsoft Excel 2002 \| All Microsoft Excel Versions \| New in Excel 2002 \| New in Excel 2003 - Office 11
Website	Home \| Tip of Hour \| Recommended Tips \| Most Viewed Tips \| Tips by Version \| Submit a Tip \| My Tips Microsoft Excel Tutorials \| Excel Links \| Write for Us \| About Us \| Search Results \| Tip Archives \| Excel Forum \| Excel Forum Archives
Excel Book	Excel 97 Book \| Excel 2000 Book \| Excel 2002 Book \| Excel XP Book \| Book Store

Terms and Conditions of use The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation Site Developed By: Varien