Auto Recovery?
 

Chippy

To add to Chip's posting.......

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery is it. This is not the same as Autosave which made true
incremental saves at intervals.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 and does the job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

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

On Tue, 14 Sep 2004 13:11:10 -0700, "CCE-Chippy"
wrote:

I accidentally closed all of my open files when I only meant to close one.
Naturally, one of the spreadsheets that closed had not been saved in a while.
I have Auto Recover set for every 10 minutes - but I can't find the last
recovery file. Will Auto Recovery not help with an accidental closing? Is
there anything I can do to retrieve the pre-saved document or do I have to
start from scratch? AHHHHHHHHHHHHH.