Forum Discussion
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
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.
