Submitted by: Srinath M S(srinath_ms@yahoo.com)

Monday May 14th 2018 by Srinath M S

Language: Enterprise, Expertise: Beginner - Updating pivot tables manually is tedious. See how to update them all at once via a macro.

A lot of Excel reporting uses pivot tables and it is necessary to update them with the latest data. The process of updating each and every pivot table via the right-click menu or through the File-menu is cumbersome.

Instead, it is better to write a macro. Place the code below to update all pivot tables in a worksheet. The loop takes care of all pivot tables in the active worksheet. It is as simple as that.

Dim pivotTable As pivotTable
 For Each pivotTable In ActiveSheet.PivotTables
Mobile Site | Full Site