Jan 19 2021 02:38 AM
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 select their teaching group. However, someone keeps removing the filter, and because it is protected it can;t be re-added whilst using SharePoint.
Two questions really:
1 - Is there a way to unlock the sheet whilst it is on SharePoint?
2 - How can i stop people going to the data tab and removing the filters? (I have given clear instructions to staff on how to use it and what not to press)
Thanks,
Niall
Jan 19 2021 05:11 AM
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)
Jan 19 2021 11:40 PM
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?
Jan 20 2021 01:00 AM