Looping through Pivottables

[johnb]

How do you loop all pivottables in a workbook to refresh
them when source data in changed?

TIA
johnb

 

[Frank Kabel]

Hi
without looping try
ActiveWorkbook.RefreshAll