Pivot tables not exist in report connection menu

[Kadir_erken]

I'm trying to control multiple pivot tables in Excel with a single slicer, but in the Report Connections section, only up to 3 tables appear at a time. How can I make the other tables visible in report connection menu?

[#2 · Accepted solution]

@Kadir_erken 

Slicer is applied to the PivotTables where is used the field from the same source. If you have one-to-many relationships, hide related field on many side and use in PivotTable such field only from one side.

[#3]

Thanks i check the pivot tables and change all data sources to one table it solves my problem

[#4]

@Kadir_erken , you are welcome, thank you for the feedback