Do you know how to do auto save in Excel?

D

Dave Peterson

What version of excel are you using?

If you're using xl2k or lower, you can install the AutoSave addin (you may need
the CD if you didn't install it previously).

If you're using xl2002 or higher, then AutoSave was replaced with AutoRecovery
(mostly used if excel/windows crash). It's not the same as autoSave, though.

If you still have your old version of autosave.xla, you can use it with xl2003.

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top