Posted on 23 September 2008
While working with multiple pivot tables, one often encounters a situation where multiple pivot tables are created with the same underlying set of data. In such cases, you may want to have the ability to simply select a value from a single drop-down and have all the pivot tables reflect that change.
A small piece of code can be used to achieve this. It uses the PivotTable.PivotFields().PivotItems attribute to check if the value selected ...
Continue Reading