Pivot tables not exist in report connection menu

Copper Contributor

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?Screenshot 2023-07-29 175135.png

3 Replies
best response confirmed by Kadir_erken (Copper Contributor)


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.

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

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