pivotfields | Excel & VBA

How to synchronize two or more pivot tables using VBA

One often comes across situations when one wants to synchronize two or more pivot tables. The problem arises when two or more pivot tables have the same underlying data set but show different views to the user. In such cases, combining both of them without losing data separation is not really an option. I wrote this small piece of VBA code a few months back that ...

How to Format a Pivot Table in Excel

Posted on 19 May 2009

In this post you will learn about how to format pivot tables in excel. Formatting a pivot table is often the step that people tend to miss out when presenting information using pivot tables. By formatting a pivot table you can make the data stand out, occupy less screen 'real estate' and make the user's life simpler. (You can download a copy of the format a pivot table in excel workbook with an example here.) How to Format a Pivot Table? Let ...

Comments

Making pivot tables move in tandem

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 ...

Comments (2)