How to disable "show fields list" for picot tables to avoid users changing the format

Question

Hi I am trying to lock the users from changing the Pivot table formats. I have protected the sheet, but it still allows them from selecting "show field lists". This needs to be disabled so that they don't change the format. any assistance would be greatfully appreciated.

Answer 1

Hi @Kristina Suh

For your need, please refer to Andreas Killer's suggestion as a workaround.

Lock or Hide Permanently Field List from Pivot Table

• Make a new sheet
• Move the Pivot table into that sheet
• Disable the Gridlines on that sheet
• Be sure no filter is applied and so the max. size of the Pivot table is shown
• Select the whole Pivot table
• Use the Camera tool and make a snapshot
• Paste the snapshot into your original sheet
• Remove the border and the fill of the picture
• Hide the sheet with the Pivot table
• Protect your sheet as usual

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---