Forum Discussion
Solved
Pivot tables not exist in report connection menu
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?
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 Replies
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
