Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
May 14, 2018

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


How to Update Pivot Tables in a Worksheet with 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 
Srinath M S
 
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