When I refresh a workbook, I have a long time before the pop-up and an other long time for the refresh.
It seems that the assigned query is running before the display of the pop-up (bug ?) and also after the modification of variables.
Have you got a solution to remove this long time beore the display of the pop-up ?