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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,118,695
Messages
5,573,673
Members
412,548
Latest member
georgepre10
Top