I have an excel file on a shared network drive that needs to be used by 2 groups of people. Group A should have read/write access. The other, Group B, only read access.
All users in the group are Authenticated Users of the domain.
I've set the NTFS permission on the excel file to the following:
Administrators - Full Control
Group B - Full Control
Users(MACHINE\Users) - Read & Execute + Read
I would assume that any users belonging to Group B would be able to make changes and save those changes to the excel file.
However, when the users open the excel file, they automatically open as Read-only.
Only Administrators are able to open the file normally.
What did I do wrong?