Excel wont autosave; how can i fix this?

[Kat]

My computer suddenly restarted while a word document and excel sheet were
open and office was set to autosave every 2 minutes so i didnt lose my work,
I found the autosave file for word but there wasnt one for excel. will excel
autosave? and how can i set it up that it will?

 

[Dave Peterson]

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

 

[Kat]

Thanks for the prompt response and i will def have a look at that AutoSafe
app but i have xl2003 so there should be an autosave file somewhere as it is
set to autosave every 2 minutes; but i cant find it

 

[Dave Peterson]

Autosave is not included in xl2002 or xl2003.

These versions use AutoRecovery--a solution for a different problem.