PDA

View Full Version : VBA to stop pivot tables refreshing before power queries with autorefresh



Benjaminst
09-02-2017, 01:10 PM
Hi

I currently have a number of queries set up that pull up datasets that are linked to pivot tables.

when I refresh the workbook, the pivotables refresh before the queries(ie Pivots are still showing the old info.)

How can one refresh all queries first and thereafter pivot tables.

Many thanks

Ben

Bob Phillips
09-02-2017, 03:40 PM
Refresh twice?