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 forma...
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.