The root problem I'm trying to solve is that I have an excel file which needs to be updated by many users, keeps getting deleted or moved. I'm trying to lock it down so users can open and write to it, but can't accidentally be deleted or moved.
File structure is a directory which contains an Excel file, and some additional subdirectories. Files are on a Server 2012R2 file server
I've created two security groups, one with full access (admins) to everything. The other security group (users) has Read & Execute, Read, and Write permissions. The permissions for admins group is applied to the top directory and allowed to inherit to all directories, subdirs, and files. Users group is also applied at top directory, and access is set to only "This folder and files" - as they should not access subfolders or any other files. No issues at all with admins group.
I created a file test1.txt and set users group permissions as described above for that file only (for testing); it works as intended (i.e. users can open and edit file, can save file - can't move or delete file).
So I created test2.txt and set users group permissions as describe above at the directory and allowed to inherit to test files it works as intended.
So here's the problem: I created testexcel.xlsx with users group permissions (I tried at the file and inherited), but users can't save file.
Why are permissions not working the same with my Excel files as with my test.txt files?