Excel VBA refresh all Pivot Table or Pivot Cache

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

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