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
pivotTable.RefreshTable
Next
Visit the DevX Tip Bank