Enable the page area only of a pivot table for protected worksheet

T

TofTaf 63

Hello All,

I want to protect a worksheet containing a pivot table but I would like to
allow the users to have access to the drop down list of the elements
contained in the page area of the pivot table.

Would anyone know if there is an easy way to do that?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Enable page area of pivot table on protected worksheet 0
Excel does not accept text format! 0
how to partially protect a pivot table based worksheet 8
Formula to Look up values from a pivot table 1
Additional columns for Pivot table 0
Slicers and Calculated Items in Pivot Table 2
VLOOKUP a Pivot Table Filter 0

Top