Refresh Queries THEN Pivot Tables

[mikepacman]

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!

 

[alansidman]

Refresh Pivot Tables Automatically When Source Data Changes - Excel Campus

Learn how to make your pivot tables refresh automatically whenever you make changes to your worksheet.

www.excelcampus.com