Recover Excel file that was saved over

[Myra]

I accidentally saved over a worksheet with another file. Can I recover the
original. I have searched and the most recent backup is from Feb. I do not
have a system that automatically backs up my files. I have tried auto
recovery, restoring the system to a previous date, searching my complete
computer. Any suggestions?

 

[Dave Peterson]

Any chance you emailed a copy to someone else. Maybe you can check your sentbox
or ask for a copy back?

How about any thumbdrive? Did you transport the file anywhere else?

 

[Myra]

Dave,

I already check both of those options and sad to say I did not. The one I
saved on my jump drive is from Feb. It got saved to a short cut on my
desktop and converted it to a .lnk file so I was hoping that the .xls file
would still be saved somewhere but my searches do not find anything. Any
other ideas??

 

[Dave Peterson]

Nope. Sorry.

Dave,

I already check both of those options and sad to say I did not. The one I
saved on my jump drive is from Feb. It got saved to a short cut on my
desktop and converted it to a .lnk file so I was hoping that the .xls file
would still be saved somewhere but my searches do not find anything. Any
other ideas??

 

[Gord Dibben]

Myra

For the future...............

Sysytem Restore does not save data files, only system files.

Autorecovery just saves a temporary file that is deleted when the original is
closed/saved with no incident.

You may want to read this...............

There is no Autosave with Excel 2002 or newer.

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

 

[Myra]

Thanks! I appreciate your help.

Myra

Myra

For the future...............

Sysytem Restore does not save data files, only system files.

Autorecovery just saves a temporary file that is deleted when the original is
closed/saved with no incident.

You may want to read this...............

There is no Autosave with Excel 2002 or newer.

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

 

[Myra]

Hi again,

I thought that if it had a different extension that the original may still
be somewhere. The new one saved as .lnk and the original was .xls. It that
possible?

 

[Dave Peterson]

..lnk files are usually shortcuts to the real files.

 

[fyz]

I accidentally saved over a worksheet with another file.  Can Irecoverthe
original.  I have searched and the most recent backup is from Feb.  I do not
have a system that automatically backs up my files.  I have tried auto
recovery, restoring the system to a previous date, searching my complete
computer.  Any suggestions?

Hi myro,

You can try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan

 

[mel.gibbs23]

I accidentally saved over a worksheet with another file. Can I recover the
original. I have searched and the most recent backup is from Feb. I do not
have a system that automatically backs up my files. I have tried auto
recovery, restoring the system to a previous date, searching my complete
computer. Any suggestions?

It's not the problem to come back your excel file to proper condition with download microsoft excel recovery software

http://www.oemailrecovery.com/excel_recovery.html