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...
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
- Hi Scott, so is your issue an inability to sort while in Excel online or the fact that sorting in normal desktop Excel puts the blanks at the top?
Thanksthe latter, that all the blanks are at top