ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how recover lost data (https://www.excelbanter.com/excel-discussion-misc-queries/220774-how-recover-lost-data.html)

Aero

how recover lost data
 
Hi There
I added and saved some data on a excel attachment and saved.But when I re
opened the data was not saved.How I can I retrive it?

Dave Peterson

how recover lost data
 
When you opened the attachment, your email program saved a copy of the file in
on your harddrive. Then it opened that file in excel.

You did your work and saved the file in that same location.

When you reopened the attachment, your email program made a second copy of the
original attachment and saved it to the harddrive and then it opened that second
copy.

If you're lucky, you may be able to find that first copy by looking in your
temporary internet file folder.

I use this:
Open internet explorer
tools|Internet options|general tab
click the settings button in the Browsing history section
Then click the View files button

Then sort by type or name or anything that would get me close.

Sometimes, the file is still hanging around. Sometimes, it's not.

Aero wrote:

Hi There
I added and saved some data on a excel attachment and saved.But when I re
opened the data was not saved.How I can I retrive it?


--

Dave Peterson

Dave Peterson

how recover lost data
 
ps. You may want to change your routine in the future. Save the attachment
from the email program to a location you want, then open from there.

Or open the attachment and before you do anything do a file|saveas and put it
somewhere safe.

Aero wrote:

Hi There
I added and saved some data on a excel attachment and saved.But when I re
opened the data was not saved.How I can I retrive it?


--

Dave Peterson

Gord Dibben

how recover lost data
 
Have a look in one of the folders in this path.

C:\Documents and Settings\username\Local Settings\Temp\Temporary Internet
Files\Content.IE5\

Assumes you have not purged your TIF folder


Gord Dibben MS Excel MVP

On Thu, 12 Feb 2009 21:17:01 -0800, Aero
wrote:

Hi There
I added and saved some data on a excel attachment and saved.But when I re
opened the data was not saved.How I can I retrive it?



Bob I

how recover lost data
 
Unfortunately by having reopened the "attached file", it was copied into
and then opened in the same place as before, thereby over writing the
"saved" version. Their changes will not be there. If one has the
presence of mind to go there before the attachment is reopened, then the
changed file may be recovered.

Gord Dibben wrote:

Have a look in one of the folders in this path.

C:\Documents and Settings\username\Local Settings\Temp\Temporary Internet
Files\Content.IE5\

Assumes you have not purged your TIF folder


Gord Dibben MS Excel MVP

On Thu, 12 Feb 2009 21:17:01 -0800, Aero
wrote:


Hi There
I added and saved some data on a excel attachment and saved.But when I re
opened the data was not saved.How I can I retrive it?






All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com