Report of slicers not working?
in
Data Analysis with Excel Pivot Tables
/
This is how the report can be used in practice by high-level executives
I tried to make a second pivot table in practice exam 2, and connect it with one of my slicers from pivot table 1. but it wouldnt appear in the downstream menu of available pivot tables to connect with. Only the original pivot table appeared there. Any ideas how to resolve this?
1 answers ( 0 marked as helpful)
Hi Panagiotis,
Please make sure both pivot tables are on the same worksheet: If the pivot tables are in separate worksheets, the slicer may not be able to connect to both of them. Try moving both pivot tables to the same worksheet and then connect the slicer.
Best,
Ned