Autorecover deletes the temporary file if excel closes normally (or when you
close that workbook normally).

Autorecover is made to help you out if excel crashes (or windows crashes).

For the future...

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

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.

Paul Ponzelli wrote:

I had a file open in Excel 2002 in which I made some changes, and then
mistakenly closed without saving. But after making those changes, and
before closing, it had remained open for over an hour.

I'd like to recover those changes, and the path specified in the
"AutoRecover save location:" text box in the Options - Save dialog tab is:

C:\Documents and Settings\MyUserName\Application Data\Microsoft\Excel\

However, I couldn't find a *.xls file in that directory. (The only thing in
that folder is a file named Excel10.xlb and another folder named XLSTART).

I don't understand why I can't find a backup file in that folder, because
the "Save AutoRecover info every X minutes:" settings are enabled (checked),
and set for every 10 minutes.

According to Excel Help for AutoSave, the file should be saved every 10
minutes in that directory. The "Disable AutoRecover" check box on that same
tab is disabled (unchecked), so it would seem the feature should work.

Is there any reason why the AutoSave feature would not be working as
described in Excel Help, and whether there is another location where it
might have saved the backup file?

Thanks in advance,

Paul

--

Dave Peterson