Change order of query updates
 

I have a workbook that has a query from an SQL database on one sheet and
several pivot tables on subsequent sheets that analyse the output of the
original query.
The problem I have is that if I use the 'Update All' button, it refreshes
the data source after the pivot tables - so I have to press it again to get
the pivot tables to reflect new changes in the data. Each refresh takes quite
a while to carry out, so it's annoying having to do it twice when the
underlying data has only changed once.
If I could change the order so that the data was refreshed before the pivot
tables, it would remove this problem.

Can anyone help?

When I first put the workbook together it actually refreshed the data first
(by accident, not design), which was great. However I've had to rebuild it
and since then it has the problem described above.
Thanks in advance

Change order of query updates
 

You might consider running your Queries from macros within Excel. That way
you can control what happens to whom and when.........

hth
Vaya con Dios,
Chuck, CABGx3



"ste1000" wrote:

I have a workbook that has a query from an SQL database on one sheet and
several pivot tables on subsequent sheets that analyse the output of the
original query.
The problem I have is that if I use the 'Update All' button, it refreshes
the data source after the pivot tables - so I have to press it again to get
the pivot tables to reflect new changes in the data. Each refresh takes quite
a while to carry out, so it's annoying having to do it twice when the
underlying data has only changed once.
If I could change the order so that the data was refreshed before the pivot
tables, it would remove this problem.

Can anyone help?

When I first put the workbook together it actually refreshed the data first
(by accident, not design), which was great. However I've had to rebuild it
and since then it has the problem described above.
Thanks in advance