Solved

.tmp files are not automatically removing themselves in Excel 2007

Posted on 2009-05-11
1
774 Views
Last Modified: 2012-06-21
Recently - over the past 2 weeks I have noticed that when I open an excel file with the older extension    .xls in Excel 2007, it creates a tmp file as normal, but after closing the file the tmp file remains there even after a reboot.  Whats interesting about it is that an  Excel 2007 with the .xlsx extension does not have this issue.  The only changes in my system recently has been from Trend PC-Cillin 2007 to Trend PC-Cillin 2009.  The problem with this is that sometimes when I try to open one of the older files I am getting Sharing Violations and the error indicates that the error is due to the tmp file still being open.  Any help on this would be appreciated.
0
Comment
Question by:OrnburnBu01
1 Comment
 
LVL 9

Accepted Solution

by:
Ramanhp earned 500 total points
ID: 24472415
In Excel go to Tools/Option/Save and remove the tick in the box opposite AutoRecovery. That will stop the creation of those files but it will also remove the AutoRecovery feature.

Alternatively - in the same location increase the time between saving the AutoRecovery information to much longer - so producing fewer files that need to be deleted.


fyi >>http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22919617.html
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now