excel crashed before saving. Where is draft of file?

[km]

excel crashed before saving. Is there a location where temp files are stored
so I can retrieve it?

[Dave Peterson]

xl2002+ has an autorecovery feature that may have helped--but only if you had it
turned on. And if you do have that turned on, the next time you start excel,
you would have been prompted to find out if you wanted to recover those files.

If you didn't get the prompt, you didn't have it enabled.

Sorry.

Just some info for the next time:

xl2002 added an autorecovery feature that can be turned on by the user. It
saves a copy of the workbook every xx minutes (user selectable).

If excel/windows crashes, the next time you open excel, it sees that file and
asks if you want to recover from the crash.

Before xl2002, there was an autosave addin that you could use. It actually
saved the file every xx minutes (againg selectable by the user). But it wasn't
made to recover from crashes--it just saved right over the file.

Jan Karel Pieterse wrote an 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.)

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

=====

And Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

km wrote:
>
> excel crashed before saving. Is there a location where temp files are stored
> so I can retrieve it?

--

Dave Peterson