Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Temp files (Excel 2002)

    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.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Temp files (Excel 2002)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Temp files (Excel 2002)

    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.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Temp files (Excel 2002)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •