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...
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
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