Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last 10
minutes so I could retrieve it. Where does the PC save the work to in order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

Louise

ToolsOptionsSave

You will see a path in "autorecover save location"

Follow that path in Windows Explorer.

Look for *.xar files.

If you find one with a recent date/time rename it to *.xls and open it.

Lots of luck.

The Autorecover files are generally dumped when you close the file normally.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 02:11:01 -0800, Louise
wrote:

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

Hi Gord

Thanks for your reply, I'll try that. I didn't realise that once a document
is closed, the autorecover files are automatically dumped.

Thanks for your help.

Louise

"Gord Dibben" wrote:

Louise

ToolsOptionsSave

You will see a path in "autorecover save location"

Follow that path in Windows Explorer.

Look for *.xar files.

If you find one with a recent date/time rename it to *.xls and open it.

Lots of luck.

The Autorecover files are generally dumped when you close the file normally.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 02:11:01 -0800, Louise
wrote:

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

I have just tried what you suggested and there are no files in there of *.xar
type, only one file of *.xlb format. It obviously hasn't kept the changes I
made which I didn't save.

Oh well, I'll have to be more careful in future!

Thanks again.
Louise

"Gord Dibben" wrote:

Louise

ToolsOptionsSave

You will see a path in "autorecover save location"

Follow that path in Windows Explorer.

Look for *.xar files.

If you find one with a recent date/time rename it to *.xls and open it.

Lots of luck.

The Autorecover files are generally dumped when you close the file normally.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 02:11:01 -0800, Louise
wrote:

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise

Louise

Some info for your perusal and possible assistance in future.

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as
there was in earlier versions.

Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave
which made true incremental saves at intervals and alerted you before saving.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe
which also doen't alert before saving.

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or
puts them in the recycle bin). And the user can always restore the backups
from the recycle bin.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)


Gord

On Wed, 6 Dec 2006 00:59:00 -0800, Louise
wrote:

I have just tried what you suggested and there are no files in there of *.xar
type, only one file of *.xlb format. It obviously hasn't kept the changes I
made which I didn't save.

Oh well, I'll have to be more careful in future!

Thanks again.
Louise

"Gord Dibben" wrote:

Louise

ToolsOptionsSave

You will see a path in "autorecover save location"

Follow that path in Windows Explorer.

Look for *.xar files.

If you find one with a recent date/time rename it to *.xls and open it.

Lots of luck.

The Autorecover files are generally dumped when you close the file normally.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 02:11:01 -0800, Louise
wrote:

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise






Gord Dibben MS Excel MVP

Hi Gord

Thanks very much for all the info, I'll give the download a try for future.

Thanks again for all your help.
Louise

"Gord Dibben" wrote:

Louise

Some info for your perusal and possible assistance in future.

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 as
there was in earlier versions.

Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave
which made true incremental saves at intervals and alerted you before saving.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe
which also doen't alert before saving.

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or
puts them in the recycle bin). And the user can always restore the backups
from the recycle bin.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)


Gord

On Wed, 6 Dec 2006 00:59:00 -0800, Louise
wrote:

I have just tried what you suggested and there are no files in there of *.xar
type, only one file of *.xlb format. It obviously hasn't kept the changes I
made which I didn't save.

Oh well, I'll have to be more careful in future!

Thanks again.
Louise

"Gord Dibben" wrote:

Louise

ToolsOptionsSave

You will see a path in "autorecover save location"

Follow that path in Windows Explorer.

Look for *.xar files.

If you find one with a recent date/time rename it to *.xls and open it.

Lots of luck.

The Autorecover files are generally dumped when you close the file normally.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 02:11:01 -0800, Louise
wrote:

Hi, thanks for your reply.

So, when my PC crashes, where is the recovered file stored? Is it not
possible to 'find' the last auto saved version of a file, unless your PC
freezes?

Thanks again.
Louise

"macropod" wrote:

Hi Louise,

Only be re-doing them - unless you had some form of logging system running,
which is unlikely.


--
macropod
[MVP - Microsoft Word]


"Louise" wrote in message
...
Hi all

I have a large worksheet which had been saved, however, I then edited the
worksheet but closed it without saving the changes. Is there any way I
can
retrieve those changes??

My initial thought was that this isn't possible, however, if my PC had
crashed, the autorecover feature would have saved my work up to the last
10
minutes so I could retrieve it. Where does the PC save the work to in
order
to recall the autorecover file after it crashes? Would this be where my
workbook was stored when I didn't save it?

I have spent hours on this file - any help would be appreciated.

Thank you.
Louise






Gord Dibben MS Excel MVP