Jan Karel Pieterse's AutoSafe is the way to go:

http://www.jkp-ads.com/Download.htm

It saves a copy into a holding directory, then removes those to the recycle
bin. I end up using the recycle bin as a one or two week archive.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
gc

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and
2003 as
there was in earlier versions.

Autorecovery from ToolsOptionsSave is it. This is not the same as
Autosave
which made true incremental saves at intervals and alerted you before
saving.

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 on 2002 and 2003 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
which also doen't alert before saving.

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 MS Excel MVP

On Wed, 10 Jan 2007 05:54:01 -0800, gc
wrote:

I have a backup utility that failed at the same time I had a hard drive
failure, resulting in a highly inconvenient loss of data.

I want to employ autosave as an alternative, writing to a memory stick,
instead of a shared drive, for speed. I can't seem to make it work. Has
anyone made this work?

Office 2003, Win XP Pro.

Thanks