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!
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!