Dealing with macros that include refreshing web query?

[JumboCactuar]

Hi,
I have a workbook that contains many refreshable web queries which I refresh using a command button.

But how can I "pause" the VBA until queries have finished? As they take up to 2 minutes to complete and I want to manipulate the data afterwards

Appreciate any help

 

[Coding4Fun]

You might also check the properties of the connection and queries to make sure it is set to Enable Background Refresh, it is an option within the settings of the connection and i believe I saw it in the query as well.

That is what i was trying to say with this statement but it came out wrong, you wanted to "Untick" or Disable Background Refresh in the options as you mentioned was your solution. I mistakenly said to enable it, my apologies for the error.

Glad you got it worked out.