Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 846
Default How can I open an excel .tmp file?

I am tring to recover an excel .tmp file and it will not open in any program.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How can I open an excel .tmp file?

Opening a .tmp file in Excel can be a bit tricky, but it is possible. Here are the steps you can follow:
  1. Open Excel and click on the "File" tab.
  2. Click on "Open" and navigate to the folder where the .tmp file is located.
  3. In the "Open" dialog box, change the file type to "All Files (*.*)" to see all files in the folder.
  4. Locate the .tmp file you want to open and select it.
  5. Click on the drop-down arrow next to the "Open" button and select "Open and Repair".
  6. Choose the repair option that best suits your needs. You can choose to repair the file, extract data, or cancel the operation.

If the above steps do not work, you can try renaming the .tmp file to .xls or .xlsx and then try opening it in Excel. To do this, right-click on the .tmp file, select "Rename", and change the file extension to .xls or .xlsx.

If none of these methods work, it is possible that the .tmp file is corrupt and cannot be recovered. In this case, you may need to try a file recovery tool or contact a professional data recovery service for assistance.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 217
Default How can I open an excel .tmp file?

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

"Brad" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default How can I open an excel .tmp file?

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.


Louise wrote:
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

"Brad" wrote:

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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 217
Default How can I open an excel .tmp file?

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

"willwonka" wrote:

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.


Louise wrote:
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

"Brad" wrote:

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





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How can I open an excel .tmp file?

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.

Brad wrote:

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


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default How can I open an excel .tmp file?

Correct

Louise wrote:
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

"willwonka" wrote:

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.


Louise wrote:
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

"Brad" wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saved *.csv file gives SYLK file type warning upon Excel 2003 open Tom Excel Discussion (Misc queries) 5 March 19th 08 04:15 PM
Excel Outlook Attachments opening after several errors everytime cito_support Setting up and Configuration of Excel 2 March 13th 06 07:15 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 03:26 AM
Why Excel file doesn't open by double click. Siraj Excel Discussion (Misc queries) 1 February 6th 05 02:58 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 11:50 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"