Hello,
I have an the excel book with sheets that are password protected so that the users cannot delete rows or columns.
In each sheet I gave permissions for certain ranges that need to be filled out only to specific users that need to fill out those cells.
The users are located and managed in the Active Directory.
The point is that each user can only update his/her sheet within the Excel book.

It was working for a day or two and then all of a sudden without any changes all the permissions were gone and every user was able to edit every sheet.

I would appreciate any help in this manner.

Thank you in advance,
Shani