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
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