Prevent Deletion of file but allow to modify

We have a situation that our management wants users to be able to open an Excel file and edit the contents and save but not allow them to accidentally or on purpose delete or move the file. Is there some method in Windows to configure a file share like this?
Who is Participating?
oBdAConnect With a Mentor Commented:
Not possible, at least not with Office documents. Excel saves a file by first writing a new(!) temporary file, and if that was successful, it will delete the original and rename the temporary file to the original file name.
In other words: in order for a user to be able to save an Excel document, he'll have to have permissions to delete it as well.
Description of the way that Excel saves files
That aside: even if it were possible, it would still not prevent any accidental or deliberate deletion of data contained in the document. If you can edit the contents, you can edit them to contain nothing, and then save an empty file.
You have to change permission on NTFS volume, where files are stored.

This can be done by modifying the advanced security permissions of the folder/file and make sure that the users do not have permissions  "Delete"  for files and "Delete Subfolders and Files" and "Delete" for folders, so You have to set DENY on these permissions.

And there is useful informations
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Explain shadow copies to management and move on.
There are specific files and folder monitoring software that would be able to let you know what changes have been made at the files and folder with in the software.

As the requirement you are asking about there is a very less chances as because these changes are a part from the NTFS setting. You can go for a file server monitoring tool and by that you can identify who so ever accessed you excel file or any other files with in you r server.

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.

All Courses

From novice to tech pro — start learning today.