• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

NTFS permission Win2k8 Srv

Hello ,

I would like to have a folder permission to not to create any file or folder but to update existing Excel files.

I have tried everything with special permission but in vain ,it's not allowing users to update the file.

  • 2
2 Solutions
Have you tried only giving modify permission?
Not possible, sorry. When Excel saves, it first writes to a temporary file in the document folder, then the original file is deleted and finally the temporary file renamed to the original name. In other words: if a user can not create files in a folder, he can't save/update Excel documents in that folder.
Description of the way that Excel saves files
Then there really isn't a way to do what you're looking for. Excel will always create that temporary file and unless you grant read/write/modify the users, they won't be able to do anything.

Either grant the users read/write/modify to that folder, or find somewhere else to put those files.

You could also set up versioning for that folder and allow a check out/check in process. That would ensure that it only modifies the file without allowing the user to do otherwise with it.
Excel and any office file requires create and delete writes dealing with lock file ~filename that s created to make sure no two users open the same file for modifications.
Depending on what you want to alive, auditing might be what remains, you could use a document management system where users can checkout the file, edit it locally and then upload it back.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now