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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,114,652
Messages
5,549,209
Members
410,905
Latest member
Extjel
Top