Apr 18 2022 02:56 PM
I'm trying to allow users to access the slicer for my donut chart without having the ability to move/delete the charts themselves. I started by unchecking "locked" on the slicer. I then protected the sheet with the following checked: Select Unlocked Cells, Use AutoFilter, Use PivotTable and PivotChart.
I still get the error that I can't use a slicer on this protected sheet. Is there a way around this?
Thanks!