February 18, 2022
I'm using Excel 365 in windows and have some issue.
it's possible to connect 2 or more table using slicer ? it's not fit if changing all data to pivot due the visual it's quite not good or maybe there is another way that i don't know can share with me.
here the example file. how to make cell F3 changing follow the slicer depend on the month selected? the PORD data pick up from "sheet 1"
July 16, 2010
Slicers can only control a single table. If you want to control multiple reports, then you can create PivotTables from your Table source data and then connect PivotTable Slicer to multiple PivotTables. Note: Slicers can only control multiple PivotTables where those PivotTables reference the same source data. If you have separate data sources, then you'd need to use Power Pivot.
More on Slicers for PivotTables here.