I must add, that when I create a new slicer with the new pivottable this works. Now I tried to connect this with the first pivottable and now only the new pivottable shows up in the connection window.
The pivottables both use the same data set. Only the old one, filters a couple of records out. Which I need to show up on my dashboard. That's why I created a new pivottable.
It might be my lack of understanding how this connection/pivot tables work. As I do not have a clue, why it is not showing up in the connection screens.
You are Welcome!Thanks Vishal, Just copying the pivot table was sufficient. The links were created automatically.
BTW, is this the way to work in Excel? Or is there an explanation why creating a new table using the exact same data is not working?
For users in the future having this issue, I would confirm the exact same data is being used by each pivot table you want to link.BTW, is this the way to work in Excel? Or is there an explanation why creating a new table using the exact same data is not working?
I also struggled with the problem of not seeing the pivot tables when i right click slicer < report connections . I used Vishal's solution of copying and pasting the original pivot to make copies. I also make it a good practice to custom name all my pivot tables and slicers to make tracking easier. Looks like what works in excel 2010 does not work exactly in the same way in Excel 2013.
Ok so I had the same problem, working on some trial/error.
First off when you create your slicer it can't be the same field as the pivot tables current field that you're creating the slicer from (eg. pivottable1 uses "User" field then the slicer stemming from pivottable1 can't be sliced by "User" other wise you can't make the connection to another pivottable)