• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Linking Multiple Pivot Tables


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.