View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Retrieving unsaved work

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