Refresh all query & save. not enough time for query to complete.

Hi everyone,

I have a very simple workbook with a couple tables. Manually I hit the refresh all button and save it.

I tried to automate it (very simple)

HTML Code: 

It return a warning error Capture.PNG
I dont know if you can read the above screenshot, it displays the following: "The action will cancel pending Refresh Data Comman, Continue?" YES NO

Would you have any suggestion.

Thanks
Phil

PS: I tried delaying the saving process by 10 sec, but even after 10 seconds I still get the above warning message. note that if I do it manually, it only take a blink of an eye to refresh.

Try editing all of your connections (that are being refreshed) and set the BackgroundQuery=False.