Forum Discussion

rodsan724's avatar
rodsan724
Brass Contributor
Oct 28, 2021
Solved

Is there a way to control Refresh All data order

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.

 

 

excel
Formulas and Functions
Macros and VBA
  • Martin_Weiss's avatar
    Martin_Weiss
    Oct 31, 2021
    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

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Oct 31, 2021
    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

Resources