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.
...
Read More
Unit 7 – Pivot Table VBA
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 ...
Read More
Create Pivot Table using Excel VBA
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 ...
Read More
Excel VBA multiple criteria in Label Filter of Pivot Table
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".
...
Read More