Report Connections Clearing "Keep only selected" filter

Techipubs

New Member
Joined
Sep 20, 2019
Messages
6
Hello and thank you for viewing my post.

I have a spreadsheet that has 5 pivot tables on 1 tab and I've created the graphs and copy / paste those graphs onto the Dashboard tab. When I add the sliders; 5 in total, I connect 3 of the graphs to the slicer without issue but when I connect the 4th slicer it clears the "Keep only selected" filter for that pivot and shows everything in that pivot even after I have select only 10 items to keep from the list of hundreds.

Is there a way to keep the filter of only the 10 I selected to keep without having the slicer clear the filter?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,790
Messages
5,574,308
Members
412,586
Latest member
Medhum
Top