Question

Can you lock a PivotTable in Excel?​

Answer 1

Answer:

STEP 1: Click on a Slicer, hold the CTRL-key and select the other Slicers. STEP 2: Right-click on a Slicer and select Size & Properties. STEP 3: In the Format Slicer dialog box, Select Properties, “uncheck” the Locked box. STEP 4: Go to the ribbon menu and select Review > Protect Sheet.

Answer 2

Answer:

• Here is a step-by-step tutorial on How to Lock Pivot Table but not the Slicers:
• STEP 1: Click on a Slicer, hold the CTRL-key and select the other Slicers.
• STEP 2: Right-click on a Slicer and select Size & Properties.
• STEP 3: In the Format Slicer dialog box, Select Properties, “uncheck” the Locked box.