Report of slicers not working?
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?
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.