Louise
Some info for your perusal and possible assistance in future.
If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as
there was in earlier versions.
Autorecovery from Tools>Options>Save is it. This is not the same as Autosave
which made true incremental saves at intervals and alerted you before saving.
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 on 2002 and 2003 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
which also doen't alert before saving.
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
I have just tried what you suggested and there are no files in there of *.xar
type, only one file of *.xlb format. It obviously hasn't kept the changes I
made which I didn't save.
Oh well, I'll have to be more careful in future!
Thanks again.
Louise
Gord Dibben said:
Louise
Tools>Options>Save
You will see a path in "autorecover save location"
Follow that path in Windows Explorer.
Look for *.xar files.
If you find one with a recent date/time rename it to *.xls and open it.
Lots of luck.
The Autorecover files are generally dumped when you close the file normally.
Gord Dibben MS Excel MVP
Hi, thanks for your reply.
So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?
Thanks again.
Louise
:
Hi Louise,
Only be re-doing them - unless you had some form of logging system running,
which is unlikely.
--
macropod
[MVP - Microsoft Word]
Hi all
I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??
My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?
I have spent hours on this file - any help would be appreciated.
Thank you.
Louise
Gord Dibben MS Excel MVP
