Temp files (Excel 2002)

**JudyJones** · 2005-03-09 10:57

I have a user I help support who has many .tmp files being created by Excel. I deleted all the .tmp files and turned off the option to save the file every 10 minutes thinking that was causing this problem but they are still being created. I searched this forum and other problems revolving around temp files seemed to stem from addins or code, of which there are none. The only article I could find on the Microsoft knowledge base pertained to Word's creation of temporary files. Does anyone here have any other thoughts on why Excel would create temp files that continue to multiply and are not deleted once Excel is closed.

**HansV** · 2005-03-09 11:16

Sometimes, anti-virus software interferes with the automatic deletion of .tmp files that should occur when Excel is closed. You could test this by temporarily turning off the anti-virus software, then opening and closing a few Excel workbooks. Don't leave the anti-virus software off permanently!
If the AV is the culprit, you could visit the manuafacturer's website to see if there are updates or patches available for this problem.

**JudyJones** · 2005-03-09 12:07

Thanks. I'll have someone research that possibility. Other than that my only other thought was to have them open each Excel file using a batch file that would delete all .tmp files each time after they exit their Excel file.

**HansV** · 2005-03-09 12:13

The reply in this newsgroup thread has sample VBScript code to delete temporary files.

Thread: Temp files (Excel 2002)

Thread Tools