Temporary files with Excel in network

[stayingcool]

I'm wondering if someone came across this situation.
I have a shared Excel Workbook on a shared folder in the network. I
have set the share permissions to READ and CHANGE. Then the local
folder permission is set to READ,WRITE,LIST Folder Contents and
Execute(These permissions are not inherited to the subfolders and
files).

The shared Excel Workbook has all permissions except Delete. When users
access and save the Excel sheet I see there are lots of temp files
getting created; Example
B7013930
AF303930

Doing a little bit of research in the Microsoft Website I saw the below
article
http://support.microsoft.com/kb/814068/

Going through the article I see that it is a permissions issue where
the Save feature of Excel is not able to delete the old Workbook and
rename the temp file(with updates) to create the new updated workbook.

Hence if the logic of Excel saving the files necessiates that we give
Delete permissions then we might be in a risk of losing the file if
someone deletes it unknowingly.

If we don't want to give the delete permission then we need to deal
with the temp files.

Any suggestions?

 

[Guest]

We are having the same problem. I have looked at all our files properties
and all of the have delete enabled and we still receive so many temp files a
day that we can't keep up with all of them.
To keep them from staying on the server, we do the following:
create a folder within the folder of your original file, name it temp,
then move the temp file in the new folder.
Go into the new folder and rename the temp file the exact same name as your
original file, giving it an .xls extension.
Right click on the file and copy it.
Go to the folder of your original file, right click, and paste.
It will ask you if you would like to replace the existing file. Yes.
This will update your original file as well as keep the temp file from
taking up space.
Hope this helps until you can come up with a permenant solution.
We are still looking for one ourselves : )