How can you setup to save your excel XP document automatically?

[JJared]

There use to be an add-in for excel 2000 that saved your document
automatically. Is there an add-in availabe for XP? The recovery function
for XP only works if your computer shuts down accidently. It does not work
if someone shuts down excel accidently, and forgets to save your document.

 

[Nick Hodge]

The old add-in may work if you can get it from an old installation
(Autosave.xla)

It may however conflict with the current one, which is much improved for
it's primary function...crashes.

You could put some code in the personal.xls workbook_close() event, which
asks 15 times "Are you sure you want to close?"

Alternatively, if this is just one particular model you could put an auto
save line again in the Workbook_close(). This may be frustrating as any
what-if scenarios would save when maybe the user didn't want them to. You
could however, make the save to another back-up file

More user education one feels ;-)

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

 

[Duke Carey]

Download Jan Karel Pieterse's AutoSafe from
http://www.oaltd.co.uk/MVP/Default.htm.

 

[Gord Dibben]

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

Autorecovery from Tools>Options>Save 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