Pivot tables and connections

[nparsons75]

Hi, I have multiple pivot tables and various slicers connected to them. I have since needed to create a new pivot table using the same source data. I then want to connect the existing slicers I am using to the new pit table. However, when I try this, the new pivot table does not appear in the pivot table connections list?

Does anyone have any idea why this may be and how to get around it...

Thanks in advance.

 

[RoryA]

That should only happen if the source data is not exactly the same as the others. I tend to just copy an existing pivot table and then change the fields on it.

 

[nparsons75]

Yep, that was it....I dont understand how it happened but I ended up with 2 sources...Thank you for pointing me in the right direction.