How can I set access permission to users for Read, write and modify in one excel file but they cannot delete excel file.

_{Monday, October 21, 2013 6:02 AM}

How can I set access permission to users for Read, write and modify in one excel file but they cannot delete excel file. We have windows 2008 file servers and active directory.

qamrul

_{Tuesday, October 22, 2013 8:10 PM ✅Answered}

So I even made a blog article about this.. 

It has the way it works and a big beautiful Process Monitor dump which shows why it wont work to disable delete.

The big steps of excel are:

1. Save to newfile
2. Rename excelfile to oldfile
3. Rename newfile excelfile
4. Remove oldfile

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. Even if you are not the author of a thread you can always help others by voting as Helpful. This can be beneficial to other community members reading the thread. Oscar Virot

_{Monday, October 21, 2013 6:11 AM}

How can I set access permission to users for Read, write and modify in one excel file but they cannot delete excel file. We have windows 2008 file servers and active directory.

qamrul

Im assuming this is a file on a network share. You should be able to modify the files ACL to do an implicit deny on the delete attribute, which should do the trick. Go to the files properties, then to the security tab, then click on advanced, change permissions, then edit the unser(s) you want to deny delete access to. Check the deny box next to delete and you should be good to go.

_{Monday, October 21, 2013 7:07 AM}

Hi Chin Diesel,

i setup permission as per ur process, as a result users can't save in same file show save as file new file name.

pls. give another process. waiting for ur reply.

_{Monday, October 21, 2013 4:03 PM}

Do you have this on a network share? The effective rights is the most restrictive combination of share permissions + NTFS permissions, so you could give the share full control, and then just set NTFS permissions to deny the delete capability. Let me know if that helps you out.

_{Tuesday, October 22, 2013 4:44 AM}

we have set permission as per ur prosecc, but not work, cannot save file without modify permission, if modify it can be delete file. if any solution pls. know me.

_{Tuesday, October 22, 2013 5:30 AM}

Hi.

Due to the way that Excel saves files it is impossible.

Excel will save the updated file as a temporary file and then remove the old and renaming the files. Therefor the feature you are requesting cannot be done.

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. Even if you are not the author of a thread you can always help others by voting as Helpful. This can be beneficial to other community members reading the thread. Oscar Virot