Limiting Slicer multiple selection

[Paul-NYS]

Hi
I have a pivot table that is linked to charts and has several slicers. Is there any way to limit the number of items a person can select in a slicer to just one? If you hold down the control key, you can select more than one slicer option, which messes up the chart numbers (to put it in non-sophisticated terms).

Paul

 

[bsalamone]

Hi, did the question in post #14 ever get answered? I have the same issue; I can get the code to work for a single slicer but I have several slicers that need to be limited. I tried copying and pasting the code directly underneath the first piece of code (and changing the slicer name) but I get the following error:

Compile error:

Ambiguous name detected: Workbook_SheetPivotTableUpdate

Please help!

 

[aalbarak]

Hi bitechie,

Here is some code for you to try. Paste the code into the ThisWorkbook Code Module of your Workbook....

Hi Jerry,

I have two slicers from the same pivot table that i would like limit to a single selection, how would i update the code in order to include a second slicer?

Thanks,

Abdulla

 

[rtgjeg]

I know this is old thread, but I haven't been able to find any other solutions on the internet. I'm getting an "Application-defined or object-defined" error in

If slc.VisibleSlicerItems.Count > 1 Then