Auto save

[Guest]

I have just installed the auto save add-on for Excel. I set it to
automatically save without prompting me, but it doesn't remember my setting,
so everyday I come to work I have to configure it to save without prompting.

Shouldn't it remember my setting so I don't have to keep doing this? I know
that Word has this ability.

 

[Gord Dibben]

Excel 2002 and newer does not have AutoSave aad-in.

I will assume you are running Excel 2000 or older.

Office 2000 Autosave had a bug which was corrected in a Service Release.

Try the advice below from Dave Peterson............

Dave Peterson Jul 21 2004, 6:49 pm

Maybe...

http://support.microsoft.com/default.aspx?scid=kb;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000

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



Gord Dibben MS Excel MVP