Forum Discussion
View-Only user with abilit to use Slicers
Is there any way I can allow certain users of an Excel Workbook to interact with/ make selections on the Slicers without having any (other) editing capabilities?
Thanks for that, I use a Mac on the O365 subscription latest desktop version and I don't have the 'General' tab or any way of unlocking the slicer from the protected sheet, all help gratefully rec'd
I'm on Windows but it shall be similar on Mac.
Right click on the slicer, format properties and here uncheck Locked
Protect sheet and here keep checked Use AutoFilter
With that slicer shall work on the protected sheet.
SergeiBaklan you are a genius!
Slicer setting shows only this so I didn't look further LOL:
however, slicer 'Size & Properties'Lead me to this, thank you so much! 😄 It's greyed out as I've been able to unlock the slicers and lock the sheet.
SimonH-UK , great, thank you for the feedback