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