dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: How to Update Pivot Tables in a Worksheet with a Macro

Updating pivot tables manually is tedious. See how to update them all at once via a macro.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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

 





   
Srinath M. S. says: "I would love to leave a footprint in this flat world."
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date