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