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


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 04:12:01 -0800, Al wrote:


-- 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


"David Biddulph" wrote:

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.
--
David Biddulph

"Al" wrote in message
...
where do I look for a backup copy

--
Thanks for any suggestions...Al


"David Biddulph" wrote:

Use your backup copy.
--
David Biddulph

"Al" wrote in message
...
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?
--
Thanks for any suggestions...Al