PDA

View Full Version : Excel .TMP files



rob_on_guitar
15-07-2011, 10:06 AM
At work Im running a folder that we run 2 daily excel spreadsheets out of.
The folder the excel sheets are being run off are on a department drive so others can open these files.

The issue Im having is the constant .tmp files are being made even though the excel sheets are saved and closed.
This is happening for all excel sheets (we have a months worth of sheets prepped in the folder) that have/are being used at the time.

Any help to eliminate the issue.

Or would I have to run the folder from my machine, then put the sheet on the department drive once Ive finished? (Which defeats the purpose of allowing others access).

Cheer
Rob

Speedy Gonzales
15-07-2011, 10:14 AM
This what you mean??

http://forums.techguy.org/business-applications/547658-excel-2002-creating-tmp-files.html

If it is, AV programs can cause it

rob_on_guitar
15-07-2011, 10:53 AM
Thanks mate, AV doing it. cheers.

Speedy Gonzales
15-07-2011, 11:01 AM
No probs

mikebartnz
15-07-2011, 11:32 AM
Reading that link what on earth does an anti-virus have to do with Excell saving temp files?

rob_on_guitar
15-07-2011, 11:42 AM
Not sure, Ive disabled the live monitoring and that seemed to have killed it.

inphinity
15-07-2011, 01:03 PM
Reading that link what on earth does an anti-virus have to do with Excell saving temp files?

Any decent AV will scan them, and in some cases the AV still has the file locked open when Excel tries to delete it. Instead of giving the user all sorts of errors, it just leaves them there.