I just got MS Excel 2003. What happened to the "auto save"....

[Guest]

I just got MS Excel 2003. What happened to the "auto save" button that use to be under "TOOLS" on the tool bar?

 

[Frank Kabel]

Hi

see below. In addition you may also use the old add-in if you still
have the old Excel version available

and now the repost from Dave Peterson:
------
Short descriptions:

Autosave (an addin in xl versions before xl2002), the workbook gets
saved at
user selectable intervals (just like a manual save). (If you're
running
xl2002+, then if you can find a copy of autosave, it'll work with that
version,
too.)

xl2002+ has a feature called autorecovery. It's used to catch
catestrophic
events (excel/windows crashing). But it won't help if you never save
or you
close excel normally.

But Jan Karel Pieterse has an addin that's the best of both worlds:
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.

=====
You may want to get a copy of Jan Karel's addin. It might save a few
tears in
the future.

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

 

[Dave Peterson]

And 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

 

[Jon Peltier]

Speaking from experience, though, Jan Karel's Autosafe is a better
option than autosave.xla. It's great not to have your document
overwritten every five minutes; the copies in another directory are much
less obtrusive.

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