Is there a way to auto save at an interval? Not just AutoRecover.

[Peter V]

I want to set Excel or any Office document to auto save at a set interval.
Not just autorecover.

 

[Dave Peterson]

AutoSave was removed with xl2002. But if you have an old version of
autosave.xla (it came with earlier versions of excel), it'll still work in the
newer versions (xl2002+).

If you don't have a copy available...

Another option would be to dump autosave and use Jan Karel Pieterse's addin
(works in any version) 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]

I have a copy of the older AUTOSAVE.XLA that Dave refers to.

If you want it, email me at gorddibbATshawDOTca

Change the obvious.


Gord Dibben MS Excel MVP