Macro to wait for refresh data to complete before proceeding?

[dpnab]

I'm not sure if you need to see my code, but I have a few tables that are connected via ODBC and as such, update when the file is opened (PowerQuery).

I already checked "Refresh data when opening file" but that doesn't help.

What can I add so the first thing that is done is the workbook waits to refresh the data before proceeding?

Would it need to be a separate macro and then when it's done, it proceeds to run the second macro? (I have the macro running as soon as the file is opened).

Thanks!

 

[johnny51981]

Have you unchecked the box next to "Enable background refresh" for each query that is being refreshed?

In your Queries & Connections Pane, right click over the table, select Properties, uncheck "Enable background refresh". That will allow for the data to be completely refreshed before moving to the next steps that you have set up.

 

[Xitor]

I just had the problem and had to register just so I could click the like button! Solved my issue! Thanks!