@Itchn2go
If I understand correctly, from the translation, you would like ...
The users use the filters without being able to edit the cells in the protected area.
Right from the start, I'm not familiar with Office 365, but I can send you this information that "maybe" might help you.
Our starting point is a pivot table (or a table format area) with connected data slicers.
If the worksheet is protected, we can no longer click anything.
To get around this problem we have to do the following:
1. Edit the data slicers (of course removed with the sheet protection) with a right click of the mouse
2. Select size and properties (in the example this must be done for both data slicers!).
3. In the properties menu, uncheck Locked and select the option Independent of cell position and size. 4. Then the options Use AutoFilter and Use PivotTable and PivotChart must be selected in the sheet protection menu.
With these options set you can also use the data slicers with the sheet protection activated!
All of this should also work with Office 365 with subscription.
If this is not what you are looking for information, please just ignore my message.
But if that's what you're looking for then ... Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
