Autosave in Excel 2003

[Calvnhob]

The previous version of Office all had autosave features
which allowed the user to set a time incrimate for Excel
to automatically save their document. Excel 2003 has
autorecovery, but that is very different it seems than
autosave. If anyone has any information on implementing
autosave in office 2003, I would appreciate it.

 

[Nick Hodge]

Autosave in XL97/2000 was by means of an add-in and...IMHO was very poor.
Settings were not persistent and it frequently crashed while saving. XP an
2003 both have it built-in

It can be set or disabled under Tools>Options...>Save


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Dave Peterson]

Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

====

As an alternative, you may want to consider using Jan Karel Pieterse's addin
called AutoSafe (note spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)