Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • Last Modified:

.tmp files are not automatically removing themselves in Excel 2007

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
OrnburnBu01
Asked:
OrnburnBu01
1 Solution
 
RamanhpCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now