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