How do I auto-save my excel worksheet

[Guest]

I am trying to set up the auto-save in my worksheet, and all I can find is
the auto-recover.

 

[Frank Kabel]

Hi
Autosave is not available for excel 2003. Since Excel 2002 Autorecovery
is introduced within Excel.

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

 

[Gord Dibben]

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery is it. This is not the same as Autosave which made true
incremental saves at intervals.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 and does the job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe

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)

Gord Dibben Excel MVP