{"id":1729,"date":"2021-01-31T02:12:13","date_gmt":"2021-01-31T01:12:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1729"},"modified":"2024-03-22T18:53:20","modified_gmt":"2024-03-22T17:53:20","slug":"lock-the-excel-pivot-table-but-not-the-slicer","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lock-the-excel-pivot-table-but-not-the-slicer\/","title":{"rendered":"How to Lock the Excel Pivot Table | A Detailed Tutorial"},"content":{"rendered":"

Sometimes when you are sharing an Excel Pivot Table<\/a> with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format<\/strong>.<\/p>\n

What you can do is learn how to lock pivot table<\/strong> and only allow the user(s) to select the Slicers, making your report interactive and secure from Excel novices like your boss \ud83d\ude42<\/p>\n

\n
\n\n

<\/h3>\n

Here is a step-by-step tutorial on How to Lock Pivot Table but not the Slicers:<\/h3>\n

STEP 1:<\/strong><\/span> Click on a Slicer, hold the CTRL-key<\/b> and select the other Slicers.<\/p>\n

\"How<\/a><\/p>\n

STEP 2:<\/strong><\/span> Right-click on a Slicer and select Size & Properties.<\/strong><\/p>\n

\"How<\/a><\/p>\n

STEP 3:<\/strong><\/span> In the Format Slicer dialog box, Select Properties, “<\/em>uncheck”<\/em> the Locked box<\/strong>.<\/p>\n

\"How<\/a><\/p>\n

STEP 4:<\/strong><\/span> Go to the ribbon menu and select Review > Protect Sheet<\/a>.<\/strong><\/p>\n

\"How<\/a><\/p>\n

STEP 5:<\/strong><\/span> “Uncheck”<\/strong><\/em> the Select Locked Cells <\/em>and “Check”<\/strong> the Select Unlocked Cells<\/em>.<\/em>
\n<\/em><\/p>\n

\"How<\/a><\/p>\n

STEP 6:<\/span> Enter a password<\/strong> (optional) and press OK.<\/strong><\/p>\n

\"How<\/a><\/p>\n<\/div>\n

STEP 7:<\/span> Re-enter the password<\/strong> and press OK.<\/strong><\/p>\n<\/div>\n

\"How<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

\n
\n

Download workbook – unlocked <\/span>Lock-the-workbook-Unlocked.xlsx<\/span><\/a><\/span><\/strong><\/p>\n

Download workbook – locked<\/span>Lock-the-workbook-Locked.xlsx<\/span><\/a><\/span><\/strong> (Password to unlock: myexcelonline<\/em>)<\/span><\/span><\/p>\n

This completes the tutorial on how to lock pivot table format and how to lock slicers in Excel<\/a>!<\/p>\n

Further Learning:<\/strong><\/p>\n