ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter (https://www.excelbanter.com/excel-programming/431270-disable-select-multiple-items-all-pivottable-reportfilter.html)

JRF

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