Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter
I would like to disable the 'Select Multiple Items' and '(All)'
features from a PivotTable Report Filter (Page items). I do not know how to do it. I have data for multiple years that I would like to be able to see using the filter, but it makes no sense to add data together from different years. Therefore, I do not want a user to pick All or to Select more than one year. Can anyone help? Regards John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple items in a PivotTable filter linked to one cell | Excel Discussion (Misc queries) | |||
how do I select one from multiple items | Excel Discussion (Misc queries) | |||
Disable "Select Multiple Items" in Pivot Table | Excel Programming | |||
Is there anyone knows PivotTable about "Select multiple items"(Urg | Excel Programming | |||
Select multiple items in a listbox | Excel Programming |