» Auto-Recovering/ Auto-Saving a Workbook
CATEGORY - Excel Worksheet, Workbook
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Excel Charts
- Financial Peace: Revisited
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- How to Read A Financial Report
good one!
P
goof tip.had my answer in seconds on the web...via google
Erm, but hang on...
Mr B.
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
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
This is great, keep the good work going & make life simple!
Thank you,
Anitha