Deactivate 'Select Multiple items' in a pivot table filter

[lucioxiii]

Hi,

I was wondering if there is a way to deactivate the 'Select Multiple items' in a pivot table filter?

This is to help ensure that the user has a no option to select multiple items. I know this can be done as a slicer however in my situation using a slicer is not an option.

Many thanks

[#2]

Here is a work-around:
- Insert a slicer for that field
- Copy the pivottable to a separate worksheet where you drag that field to the row-area and delete all other fields from the pivot table
- Set the Report connections of the slicer to both pivot tables
- Suppose your new pivot table is on Sheet3 and the new pivot is in column A
- Add this formula next to the "Provider" filter, next to the cell that currently says "(All)":
=IF(COUNTA(Sheet3!A:A)>2,"Please select only one item!","")

See attached