| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook Protection Password Overwritten | Excel Discussion (Misc queries) | |||
| Recovering Overwritten Workbooks | Excel Discussion (Misc queries) | |||
| Recovering An Overwritten File | Excel Discussion (Misc queries) | |||
| recovering a overwritten excel file | Excel Discussion (Misc queries) | |||
| Overwritten excel documents | Excel Discussion (Misc queries) | |||
Linear Mode
