Natasha
To set the Autorecovery interval go to Tools>Options>Save and change the
interval under "Settings".
Note about Autorecovery and the previous Autosave feature.
That would depend upon which version of Excel you are using. Always best to
state that info.
XL2002 and 2003....have Autorecovery, which does not make incremental saves
but if Excel crashes you can recover the file to the last spot in the
autorecovery cycle(you can set that in Tools>Options>Save). If Excel does not
crash, the autorecovery temp file is deleted when workbook is closed.
Earlier versions had an Autosave add-in which made incremental saves at the
time of your choosing. Once saved, there is no going back.
The AUTOSAVE.XLA from earlier versions works fine with Excel 2002.
I have tried the version from Excel 97 and it works fine.
In addition to the above......Jan Karel Pieterse has an addin called AutoSafe
It doesn't overwrite the existing workbook when it saves. It saves a copy 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 Excel MVP
