THE OBJECTIVE:
To be able to filter multiple Excel tables (NOT Pivot tables) using the same slicer.
It would also apply to having the same slicer connected to an Excel table (not pivot) and one or more pivot tables.
The reason that I want to do this is that I want the users to be able to filter in the table and then update certain data. When they do this, I want to be able to present summary reports using pivot tables (based on the selections they have made).
e.g. if they select a specific country in the Excel table and make changes, the pivot reports should give a summary for this Country.
Bookmarks