Hi,
I have a workbook with tons of pivot tables. How can I use one slicer to connect to all the pivot tables without having to tick each pivot table check-box individually? I find it hard to believe that there is not a 'select all'/'deselect all' option.
Thanks in advance