Excel VBA refresh all Pivot Table or Pivot Cache

Posted on February 14, 2015July 19, 2016 by Wyman W

This tutorial explains how to use Excel VBA to refresh all Pivot Table or Pivot Cache, and difference between PivotCache.Refresh and PivotTable.RefreshTable You may also want to read: Excel VBA refresh closed workbook Excel automatically refresh pivot table Excel VBA refresh all Pivot Table or Pivot Cache Understanding difference between Pivot Table and Pivot Cache To start with this topic, you should note the relationship and difference between refresh Pivot Table and Pivot Cache. ...

Change Pivot Table Layout using VBA

Posted on January 14, 2015February 13, 2015 by Wyman W

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

Create Pivot Table using Excel VBA

Posted on January 12, 2015July 2, 2015 by Wyman W

This Excel tutorial explains how to create Pivot Table using Excel VBA, set Print Area for Pivot Table Create Pivot Table using Excel VBA Create Pivot Table using Excel VBA is very straight forward and easy to use. If you don't understand any Object or Property that VBA Pivot Table uses, simply use "Record Macro" function to do recording to see the underlying VBA code behind each action, such as create Pivot Table, change Pivot Table Fields, select Critera, delete Pivot Table, etc. In this ...

Excel VBA multiple criteria in Label Filter of Pivot Table

Posted on January 9, 2015September 26, 2016 by Wyman W

This Excel VBA tutorial explains how to apply multiple criteria in Label Filter of Pivot Table. Problem with multiple criteria in Label Filter of Pivot Table There are three kinds of Filters in Pivot Table for each Pivot Filters - Label Filter, Value Filter, Manual Filter. In this tutorial, I will focus on Label Filter, because I use "Department" as an example, which is non-numerical. Suppose you have the below Pivot Table and you want to show Department Name contains "Fin" and "Aud". ...