recover document

[MRJ]

Yesterday I wrote a new excel document, then accidentally closed without
saving. However, enough time elapsed that it should have been auto-saved.
The recycle bin does not contain the document. Can I find it anywhere? Thank
you for any help!

 

[Pete_UK]

But if you didn't do a File | Save As then it would have had the
default name of Book1.xls - perhaps you can search for this, or better
still Book*.xls,

Hope this helps.

Pete

 

[MRJ]

But if you didn't do a File | Save As then it would have had the
default name of Book1.xls - perhaps you can search for this, or better
still Book*.xls,

Hope this helps.

Pete



Thanks a lot for replying. However, these searches didn't bring up anything.

 

[MRJ]

Which version of Excel are you using that you think has autosave? Don't
confuse that with autorecovery, which is different.

In the Excel help for autorecovery:
"Note Do not use AutoRecover as a substitute for regularly saving your work
by clicking Save on the Standard toolbar."
--
David Biddulph




I thought my computer is set to automatically save documents every 20 minutes. I must have understood. I posted on the Dell forum but have gotten no answers.

 

[Gord Dibben]

If you're using Excel 2002 or newer, there is no Autosave 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 Dibben MS Excel MVP

 

[Alan124]

Yesterday I wrote a newexceldocument, then accidentally closed without
saving.  However, enough time elapsed that it should have been auto-saved.  
The recycle bin does not contain the document.  Can I find it anywhere? Thank
you for any help!

Hi,

You may try Advanced Excel Repair at http://www.datanumen.com/aer/
This tool is rather useful in salvaging damaged Excel xls files.

Hope this helps.

Alan