Excel Tutorials | Pivot Table Macro Code

Disable/Enable Get Pivot Data

Sub activateGetPivotData() Application.GenerateGetPivotData = True End Sub Sub deactivateGetPivotData() Application.GenerateGetPivotData = False End Sub Get Pivot Data:  To disable/enable GetPivotData function you need to use

Read More »

Refresh All Pivot Tables

ub vba_referesh_all_pivots() Dim pt As PivotTable For Each pt In ActiveWorkbook.PivotTables pt.RefreshTable Next pt End Sub Refresh All Pivot Tables: A super quick method to

Read More »