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