![]() |
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 |
All times are GMT +1. The time now is 09:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com