Is there a way to control Refresh All data order

[rodsan724]

I have a database query and a table based off that. When I run Refresh All Data, I think they both run at the same time instead of one after another which would be my desired behavior.  

What ends up happening is the table based of the database query doesn't update until I run a Refresh again.

Sheets("Sheet1").Select
ActiveWorkbook.Connections("Query - Query1").Refresh
Sheets("Notes").Select
ActiveWorkbook.Connections("Query - Notes").Refresh

I'm using Excel 2016.

[#2 · Accepted solution]

Hi,
you can try this:
goto "Query Properties" (right-click on the query in the queries & connection pane) and untick the option "Enable Background Refresh". Repeat this on all your queries.

This way, all the queries are refreshed based on their dependencies, and not in parallel.

Kind regards,
Martin