Disable 'Select Multiple Items' and '(All)' in PivotTable ReportFilter

J

JRF

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
 

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

Dates In Excel 5
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Need some PWA help 0
Creating a Search using a combo box and then creating a report. 4
How to Select Multiple Emails using Surface Pen 0
PivotTable 2003 Code is not working 0
Highlight multiple items in listbox based on textbox item 1
selected Pivot Table filter items 0

Top