Many Pivottables in one Workbook

J

johnb

How can I refresh 30 pivottables in 1 workbook in one
click when the source data is changed. I'm thinking that
VB is the route like "For Each Pivottable in a
collection". Am I right? if what does the syntax look like?
 
Top