i an trying to recover a lost file that i didn't save, and there is a feature
called the document recover task pane, however i can't seem to activate it
for some reason. please assist

Hi,

It pops up if Excel crashes and offers you a option to recover your
doc.

Think you've lost your file for good if you didn't save it

You can turn on recovery via

Tools options Save Tab Save recovery

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=565040

pati

Your saved-over file is gone.

That's not how Autorecovery operates.

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as
there was in earlier versions.

Autorecovery from ToolsOptionsSave 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 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





On Wed, 26 Jul 2006 00:31:01 -0700, pati wrote:

i an trying to recover a lost file that i didn't save, and there is a feature
called the document recover task pane, however i can't seem to activate it
for some reason. please assist

Gord Dibben MS Excel MVP