When I click refresh all or call it from a macro my power queries refresh as expected, but then they are selected. Which is problematic when the sheet containing the query is hidden...
So I added code to select another cell after the refresh all, but what seemed to happen was this:
-refresh all triggered
-cell of choice selected
-refresh of a power query completes
-power query selected
How can I make excel not select the PQ? -OR-
How can I tell my macro to wait until after the PQ refreshes to select my desired cell?
Thank you much.
So I added code to select another cell after the refresh all, but what seemed to happen was this:
-refresh all triggered
-cell of choice selected
-refresh of a power query completes
-power query selected
How can I make excel not select the PQ? -OR-
How can I tell my macro to wait until after the PQ refreshes to select my desired cell?
Thank you much.
