Forum Discussion
Bonnie_Galaska22481
Aug 03, 2023Copper Contributor
Pivot Chart Protection
I'm publishing out a series of Pivot Charts to a user community. I want to protect the charts while allowing them to use the Slicers. I don't want the charts to be selected, resized, moved or formatted. How do I accomplish this? Thanks in advance!
1 Reply
Sort By
To use Slicer from right click menu on it Size and Properties -> in the right pane Format Slicer uncheck Locked.
Next, Review -> Protect Sheet and here check everything but Edit objects. Add password if necessary.