Refresh Queries THEN Pivot Tables

mikepacman

New Member
Joined
Jan 6, 2016
Messages
6
Hi,

Looking for some help with some VBA - I'm a beginner with it so it's much appreciated.

I have an Excel workbook with a number of queries on different tabs that refresh when I click Refresh All (and Excel handles these in the right order for the final Merged Query), but the Pivot Tables that they then feed into do not update.

I'm looking for a VBA code that can:
Refresh All Queries (maintaining the correct order of operations for the Merged Query)
THEN upon query completion, refresh 5 Pivot Tables

Thank you very much in advance!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,113,827
Messages
5,544,550
Members
410,619
Latest member
gregor222
Top