Select sheet after Power Query Update

I have a macro that refreshes all my power query connections. After this is refreshed, the process quickly goes through each worksheet to apparently update the tables on each sheet. The problem is that I want to select the "Main" sheet after this refresh is done, but no matter what, the tables are updated as the last step. I've tried to call another macro to select the main sheet. I've also tried putting in the application.wait command. Nothing works. It always updates the tables last. Here's what I've got so far with the code...

Please Login or Register  to view this content.

Try

Sheets("Main").Activate

Originally Posted by rorya

Try:

Please Login or Register  to view this content.

That didn't work either. It does seem to finish refreshing the query connections themselves, then the program will select the main sheet, unfortunately after that it updates all the data table associated with the queries, still leaving me on the wrong worksheet.

I am surprised this is giving me this much trouble!

That is correct. I even tried a different piece of code, same result....

Please Login or Register  to view this content.

Rorya,

I tried your code and it had the same result - it cycled through all the worksheets and did NOT return to the Main worksheet.