Hi How to write a macro to refresh all pivot tables in a workbook?
P Phil Wales Jun 22, 2005 #2 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.
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.
N nc Jun 22, 2005 #3 Hi Phil I think there is a refresh all keyword. Phil Wales said: 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. Click to expand...
Hi Phil I think there is a refresh all keyword. Phil Wales said: 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. Click to expand...
D Debra Dalgleish Jun 22, 2005 #4 Use the RefreshAll method: ActiveWorkbook.RefreshAll Or, open the External Data toolbar, and click the Refresh All button.
Use the RefreshAll method: ActiveWorkbook.RefreshAll Or, open the External Data toolbar, and click the Refresh All button.
