Forum Discussion
Filters on a protected SharePoint file
Hi, I have a excel sheet that all staff in my school access to track attendance. It is protected so that staff can only change the cells i want them to change. It has a filter to allow staff to sele...
Hi NiallMegaw
There's no way to unprotect the sheet while in the online version
One thing to consider is educating folks in the use of Sheet View, which allows individuals to select and save a filtered view without impacting others.
Or if you can put your data in a Table (Ctrl T) then you could add a Slicer (enabling Autofilter and Objects)
Thank you for this. I have tried various ways to educate those to use it.
Would a large number of users cause the filters to be removed - I'm guessing not. It is my understanding that you have to go to the Data tab in the ribbon and select filter to remove them? Is there another way that I'm not aware of?
- Hi
The number of users shouldn't be an issue. To remove the filter option completely then yes, via the data tab.
To clear filters that can be done just by clicking on the filter icon in the column heading
