How can I open an excel .tmp file?

[Guest]

I am tring to recover an excel .tmp file and it will not open in any program.

 

[Guest]

Hi all

A friend of mine created an Excel workbook and after working on it for
approximately one hour, she accidentally closed it without saving....

I realise that if it wasn't saved, she can't get it back, however, she asked
me an interesting question which i couldn't answer...

If her PC had crashed and she re-started Excel, it would have recovered the
file for her in the Recovery Pane so she wouldn't have lost all of her work
so if it is possible to recover it this way, it must have stored it somewhere
in its memory, even though it wasn't actually saved.

Can anybody answer this question? (By the way, her autorecover is set to
every 2 minutes).

Thank you.

Louise

 

[willwonka]

Take a look at Tools..Options..Save Tab. this shows where the
Autorecover files are saved. It seems to save them in a *.xar format;
but Excel will still open it.

But unfortunately, the file goes away once you close the file.

Sorry.

 

[Guest]

Hello, thank you for your reply. I will take a look in the settings.

So, even if she had looked there to find out where it would have been saved,
when you choose FIle and Close, this is automatically deleted any way? But
it stays there if it crashes? Is that right?

Louise

 

[Dave Peterson]

Is the .tmp file in your windows temporary folder?

If yes, then this isn't your file. Excel will create some temporary files for
its own use. As far as I know, there's nothing in those files that you'd want
to recover.

 

[willwonka]

Correct

Hello, thank you for your reply. I will take a look in the settings.

So, even if she had looked there to find out where it would have been saved,
when you choose FIle and Close, this is automatically deleted any way? But
it stays there if it crashes? Is that right?

Louise