ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable "Select Multiple Items" in Pivot Table (https://www.excelbanter.com/excel-programming/342632-disable-select-multiple-items-pivot-table.html)

Pasha[_2_]

Disable "Select Multiple Items" in Pivot Table
 
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!


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com