dcsimg
 

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
    pivotTable.RefreshTable
 Next 
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved