Disable "Select Multiple Items" in Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table where two members of one of the dimensions in a page
area are mutually exclusive i.e. they cannot be selected together. I have
disabled "All Items" in the dropdown, but users are still able to select both
of them individually, upon clicking on "Select Multiple Items". Is there any
way to completely disable that checkbox, so users can only select one item at
a time?

Thanks!
 
You must log in or register to reply here.

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

Get visible pivot table items 4
pivot table not getting updated 2
dynamic pivot table selection 1
Using VBA on Excel Pivot Tables 3
How Do I Change Two Pivot Table Page Selections with VBA Code 1
List of Displayed Pivot Items 1
Pivot table multiple filters 2
Storing Multiple Selected Pivot Table Report Filter Values 2

Back
Top