We help IT Professionals succeed at work.

Excel 2007 creathing .tmp files after every edit

Goraps
Goraps used Ask the Experts™
on
I have a user that when they edit this one excel file a .tmp file is created everytime. The fle is located on a windows 2003 file share... The user is using a Windows 7 Office 2007 pc. I tried removing Excel Add-ons and also turing off indexing on that folder - NO LUCK.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kent DyerIT Security Analyst Senior

Commented:
That is by design.  Anytime you are in Excel, for crash recovery it always creates tmp files.  In fact, you can rename one of these files and pop right into Excel and start working.  You may need to setup a process that automatically or periodically cleans temp files out.

HTH,

Kent
GorapsI.T. Manager

Author

Commented:
That's not true... The TMP file is removed once the excel file is saved and closed.  These tmp files are staying and multipling.
Definatly in Windows they get deleted when they are closed.  

I'm not sure about MAC's.  

I would check things out in options > Save.  

have this guy open and close the sheet for you as an example.  If he isn't saving after making changes then that might be the reason, as one of the settings is to save a tmp file if you close w/o saving.  

It should be noted that moving to another tab or scrolling around on your current worksheet is a "change" per Excel.

If you can't nail it down, in the save options you could always disable his autosave(tmp file) for that worksheet only.  

-SA
GorapsI.T. Manager

Author

Commented:
Opening the file and closing it without making any changes or moving to other tabs does not create he temp files. only went clicking save or save as.
Is this an all office enviroment?  If your working on a windows network with an apple workstation it makes sense to me that it would need to convert the file to a windows format before saving.  

I don't know, I guess you'll need someone who knows more about Apple.  

Perhaps this Link will be helpful:

http://www.excelforum.com/excel-general/489036-excel-creates-tmp-file-everytime-savig-file.html
GorapsI.T. Manager

Author

Commented:
Sorry.. I am looking at my post and I never mentioned Apple computer... It's a all PC network.
GorapsI.T. Manager

Author

Commented:
S**T!!! I see what you talking about now.. Not sure how that went into Apple Hardware!
Did you check out the link?  It says it may be related to your virus scanner, and gives a couple of other options to checkout.

It boils down to this has been a confirmed effect of having AVG virus scanner installed. on your PC.
GorapsI.T. Manager

Author

Commented:
Not using AVG. Everyone is using MS forefront. and this issue is only happening to 1 out of 70 users.
Is it profile related?  If you have someone else log onto that PC and open the same file does the same thing happen?  Or does it work normally?  

What level is this user?  Could they have customized their settings on the virus scanner?  Have windows firewall active as well as the IT installed virus protection?  have they kicked on heuristic scanning and no one else has it on?

-SA
GorapsI.T. Manager

Author

Commented:
I logged on as me and I couldn't duplicate the problem.. Seems like a profile issue. User is an administrator for the local computer and has modify for the share where the file is located.

Firewall is disabled, Virus is locked down cannot change settings.
Confirm that this user has permissions in the folder of the problem file to delete files.  It could be that simple.  (easy way to check this is to move the document to the desktop and have him open it from there and see if it creates a .tmp that doesn't go away)

Check that this is not a shared workbook on the problem computer.  Excel has a specific classification of files that are "shared"  it's problematic and could be causing the multiple .tmp files, but I would expect everyone to have that if it was related to this issue.

Well wiping the profile seems like a easy answer.  However here are some other options:

Does this user have an excel add-in that others do not?  Fast way to check...

Run excel in safe mode - in the run bar "excel /safe"

open the problem document and save it... is .tmp created?  if not it's an excel add-in this user has that others don't.

use msconfig to do a clean boot?  Try opening and saving file.  If not .tmp then this is caused by some other unusual software on this computer.

Failing those two, you could try wiping all profile related temp files... (profile corruption)

You could check VBA event triggers in the problem workbook to see if there are any save event triggers that would effect this user differently then others. (Different VBA security settings then other users)

You could compare this user's save options on the problem document to those of another user without the .tmp problem. (Customized save options for this document)

Try these KB articles:
http://support.microsoft.com/kb/271513 

Wipe the profile.  It's not an easy fix, and not worth further time.
GorapsI.T. Manager

Author

Commented:
Solution:

Confirm that this user has permissions in the folder of the problem file to delete files.  It could be that simple.  (easy way to check this is to move the document to the desktop and have him open it from there and see if it creates a .tmp that doesn't go away)
GorapsI.T. Manager

Author

Commented:
PS: Thanks!
If you don't want that user to have those permissions for the folder for whatever reason you can always adjust where excel saves his .tmp files.

Happy to help :)