I've got a weird problem. I'm running ActiveWorkbook.RefreshAll to get data from SQL via PowerQuery, and then I have a long macro to do some refreshing within the workbook.

When I run them separately, everything is great. But I run into trouble with I try to run one after the other.

Specifically, there's one data set that I refresh and then copy paste special, but the macro is running slow and so it's actually pasting "#GETTING_DATA"

I've tried Application.Wait in a few different places. I've also tried enabling screen updating. And nothing works.

Someone suggested disabling background refresh in the connections properties. Mine is grayed out, but it seems to already be disabled.

So...any ideas?

And I hope that makes sense.