Cause/fix for extra .TMP files generated

complicated

New Member
Joined
Dec 30, 2004
Messages
3
I have a problem where several users since they upgraded from Windows Vista with Excel 2007 to Windows 7 with Excel 2007 now get 2 temporary (.TMP) files generated each time after modifying an Excel document (.xlsx) and they DON'T GO AWAY!

As an example. You have test.xlsx saved on 10-29-11 at 8am, size 161KB. You open it today and make a modification and save it at 10:35am. You now have the following.

Test.xlsx -- 10-31-11 10:35am 161KB
abcde123.tmp -- 10-29-11 08:00am 161KB
sa123dkjf.tmp -- 10-31-11 10:35am 161KB

We have about 30 users who do this to about 18 .xlsx files and over a month generate over 1000 .TMP files from each time they save.

It seems like extra version backups of the same file. The users cannot delete the .TMP files off the organizational network drive, but administrators can. This is creating a space issue if every file is taking 3x amount of space on the drive and that is just with these.

I've looked at Excel Options and have not seen anything that specifies save different versions besides autorecover (saved on roaming profile directory on their own computer) and save a backup (which is not selected).

PLEASE Advise. The only thing that it could possibly be is the permissions. I've looked at the permissions and it is not the permissions as the users have read & write, but they can still modify the document. Would leaving out the checkmark for "modify" in the privileges cause these multiple .TMPs to be created and stay after the user has closed the excel file?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,214,940
Messages
6,122,361
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top