msharma864512
Member
Hi,
I have a spreadsheet which has multiple pivot tables, but they are not inter-connected.
Ideally, if we refresh a Pivot table, it should automatically refresh all the pivot tables in the workbook, but in my case, all the pivots are not getting refreshed automatically.
The underlying data/table for all the pivots is same, but still somehow all the pivots couldnt be refreshed, I will have to go to mannually refresh each pivots.
Please help me with any sort-cuts to link all the pivots, so that I can also add a slicer to filter all the pivots at once.
Regards,
Manish
I have a spreadsheet which has multiple pivot tables, but they are not inter-connected.
Ideally, if we refresh a Pivot table, it should automatically refresh all the pivot tables in the workbook, but in my case, all the pivots are not getting refreshed automatically.
The underlying data/table for all the pivots is same, but still somehow all the pivots couldnt be refreshed, I will have to go to mannually refresh each pivots.
Please help me with any sort-cuts to link all the pivots, so that I can also add a slicer to filter all the pivots at once.
Regards,
Manish