Quote Originally Posted by JWhite
This may not be relevant in your case, but if any of these pivottables share the same pivotcache you only need to refresh one of the pivottables and all the rest are refreshed automatically.
Hi All,

Based on the above, is there a VBA method of determining which pivotcache each pivottable is using?

Or

Is there a way to refresh all the relevant pivotcaches in a workbook only? This would mean that all pivottables are refreshed automatically based on JWhite's comment above.

This is useful for me as I have many workbooks where I refresh the pivottables with a code similar to that posted by Bob (xld).

regards