Enable page area of pivot table on 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

Enable the page area only of a pivot table for protected worksheet 0
Pivot Table Management 4
Excel does not accept text format! 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Space at end of multi page list to accommodate new entries 1
Pivot Tables - Filtering on summed values 0
Used Range and Source data of a Pivot Table 1
Drop Down Menu link to Pivot 0

Top