RefreshAll pivot tables but query

[Greg]

hi,

is there a way to use

ThisWorkbook.RefreshAll

to refresh all pivot tables in the workbook but leave a query "unrefreshed"?

Thanks,

 

[Jim Thomlinson]

Nope... You can traverse through all of the sheets and all of the pivot tbles
on those sheets refreshing each something like this...

sub RefreshPivotTables
dim wks as worksheet
dim pvt as pivottable

for each wks in worksheets
for each pvt in wks.pivottables
pvt.refreshtable
next pvt
next wks
end sub