Excel vba refresh query wait. If you’re looking for technical support, please visit Microsoft Support Community. I've tried to do it using various macros but none of them refreshes a query. Mar 15, 2024 · Whether you need to refresh all queries in the workbook, refresh specific queries, or wait for SQL queries to complete, we’ve got you covered with practical solutions and code examples. End Sub The problem is that the VBA starts updating the queries, then moves the "old" data to my new location. If you have multiple connections, you could loop through all connections with something to this effect: Apr 21, 2021 · Hi guys, I have a report that needs to be refreshed twice before I can work on other stuff. I can set a time-out period, but the time it takes for the query to update is very variable (between 10 sec to 2 minutes). I'd like to automate this with VBA but what I would really like to do is refresh the first 2 queries and allow background refresh to take place, but then wait until they are complete before proceeding. Right now I was only able to fix it by not calling on RefreshAll, which gives me the idea of implementing a second flow to be executed afterwards, but that's not a good workaround. com Jun 23, 2023 · Below are some tricks that have worked well for me to make VBA wait for Power Query and carry on with the following steps only after the query refreshing process is complete. Oct 20, 2022 · Your community for how-to discussions and sharing best practices on Microsoft Excel.