macro to refresh all pivot tables

Hi expert's excel 2007

I have 17 pivot tables in a worksheet. ...I need a macro to refresh all as opposed to refreshing each one in turn...
route217Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

ThisWorkbook.RefreshAll

Regards
0
 
route217Author Commented:
Hi...rgnonzo1971..

not sure I follow
0
 
Rgonzo1971Commented:
Is is more comprehensible?

Sub Macro()

ThisWorkbook.RefreshAll

End Sub

Open in new window

0
All Courses

From novice to tech pro — start learning today.