Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.tmp files are not automatically removing themselves in Excel 2007

Posted on 2009-05-11
1
Medium Priority
?
796 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
Ramanhp earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

721 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