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