Change Pivot Table Layout using VBA

Change Pivot Table Layout, why? To illustrate why we want to change Pivot Table Layout, lets see the below example. Assume that we use the following data to create a Pivot Table. We want to show the total summary, group by Department, Empl ID. Excel 2003 - Tabular layout Pivot Table layout is called "Tabular", where each grouping is in one column, and the subtotal is at the bottom of each group. Excel 2007 and onwards - Compact layout By default, Pivot Table layout is called ...
More