Forum Discussion
How to filter on protected columns in the browser/online?
We have an Excel workbook that's saved in SharePoint O365. A number of the cells are protected however we want external users to still be able to filter on these columns when they're editing the work...
Hi Rachael Vogel, when you set your sheet protection are you ticking the box to allow Autofilter?
I just tried protecting a sheet with 3 cells (yellow in image) unprotected.
When I protect the sheet I made sure the Allow Autofilter button was selected.
This then allows me to filter in Excel Online
I'm having the same problem, in Office 2016, on Windows 10 and the "use auto filter" does not allow me to filter.
Hi Scott, are you able to attach a de-sensitised version of your file for me to test out?
Wyn,
Here it is. It is currently protected with a blank password. I need to be able to sort by column J from largest to smallest without it dropping all data to the bottom of the 2000 line table. Thanks for taking a look.
Scott
