Select sheet after Power Query Update

Originally Posted by rorya

Try:

Application.calculateuntilasyncqueriesdone
Sheets("Main").Select

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!