Jacques Naude
New Member
I have a workbook, each of my worksheets connects to a different SQL database.
The databases, are identical in structure, only the data differs.
I want to create on my 1st sheet, a slicer or pivot table to filter all data on worksheets according to my choosing on my 1st sheet.
It seems with SQL source Pivot tables you can not connect different slicers to each other like normal pivot tables.
Any help would be appreciated
The databases, are identical in structure, only the data differs.
I want to create on my 1st sheet, a slicer or pivot table to filter all data on worksheets according to my choosing on my 1st sheet.
It seems with SQL source Pivot tables you can not connect different slicers to each other like normal pivot tables.
Any help would be appreciated