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

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

Comments (2)