Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I enable auto-save on Excel XP?
- Thread starter hotmale
- Start date
There i sno Autosave feature in 2002, but you can use a great little addin from one of the Excel MVPs Jan Karel Pieterse called Autosafe. the link is as follows, and I have included the text from the MVP site below it:-
The Autosafe bit is near the bottom - Click on Jan's name in the left hand frame to shortcut down to it.
The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file on disk. This is not very convenient if you planned to leave the master file intact and save the changed workbook using a different filename. It also does nothing to simplify recovery of unsaved/changed documents after a system crash. This Autosafe utility creates copies of open workbooks at regular intervals in a separate (user-selectable) directory. It does not overwrite the master file(s), that is up to the user to do, using normal methods. As soon as a workbook is closed the backup copy is deleted from the backup directory. If an abnormal termination of Excel occurs, the backup copies remain on disk, and Autosafe finds them the next time Excel is started and presents recovery options to the user. This utility is freeware only for individual (private) users. Companies and Network Administrators are invited to contact the author for a commercial (network enabled) version. Includes the following languages: English, Dansk, Deutsch, Español, Français, Italiano, Nederlands, Norsk.
Regards
Ken..............
The Autosafe bit is near the bottom - Click on Jan's name in the left hand frame to shortcut down to it.
The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file on disk. This is not very convenient if you planned to leave the master file intact and save the changed workbook using a different filename. It also does nothing to simplify recovery of unsaved/changed documents after a system crash. This Autosafe utility creates copies of open workbooks at regular intervals in a separate (user-selectable) directory. It does not overwrite the master file(s), that is up to the user to do, using normal methods. As soon as a workbook is closed the backup copy is deleted from the backup directory. If an abnormal termination of Excel occurs, the backup copies remain on disk, and Autosafe finds them the next time Excel is started and presents recovery options to the user. This utility is freeware only for individual (private) users. Companies and Network Administrators are invited to contact the author for a commercial (network enabled) version. Includes the following languages: English, Dansk, Deutsch, Español, Français, Italiano, Nederlands, Norsk.
Regards
Ken..............
- Status
Similar threads
- Locked
- Question