recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

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

recovering overwritten Excel workbook
 

Exceellent! For the future. Still trying to figure out how to recover what
was overwritten by one saved cell.
--
Thanks for any suggestions...Al


"Gord Dibben" wrote:

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