recovering overwritten Excel workbook

A

Al

I had an Excel workbook with 10 years of data. When finished entering new
data I was closing the program, and I was asked "do you want to save
changes"; I said yes. A day later when I opened the workbook to enter newe
data, there was only one cell of data...not two sheets with multiple cells
and ten years of data.
Is there any way to recover this workbook?
 
D

David Biddulph

The backup should be in the same directory as the original file. If you had
"filename.xls", there should be a "Backup of filename.xlk", providing that
you selected the "Always create a backup copy" option under "Save As". If
you didn't do so previously, I hope you will do in future.

If you haven't got a backup, it *might* be worth seeing whether opening your
file with Open Office gives you any different result from what you got with
Excel.
 
A

Al

-- Question. Even if I had an auto backup, wouldn't it be overwritten by a
"save changes " selection. I thought I had backup selected, but I did not.
It is set now.
Thanks for any suggestions...Al
 
G

Gord Dibben

The backup *.xlk will always be one version behind the recently saved
version.


Gord Dibben MS Excel MVP
 
A

Al

Exceellent! For the future. Still trying to figure out how to recover what
was overwritten by one saved cell.
 
Top