refreshing web queries

[Guest]

I placed web queries in my worksheet. And I run this simple macro and it is
working

Activeworkbook.refreshall

I can see the earth rotation symbol for some seconds. But if I placed other
commands next to this (to change .csv file to excel) the program skips the
above command and it start executing next line I cannot see the earth rotation
symbol. Help me to come out of this problem

 

[Guest]

Make sure the queries are set not to allow background queries.