I'm not a VB expert - but

You should just be able to record a macro while clicking the refresh button
for each pivot table, then assign a button to it.





"nc" wrote:

Hi

How to write a macro to refresh all pivot tables in a workbook?