"Tom Ogilvy" wrote in message
...
Each query definition should have a backgroundquery parameter. This is
obviously set to True. You need to set it to false and your macro will
wait
for the query to complete.

You could change it with this macro

for each sh in ActiveWorkbook.Worksheets
for each qt in sh.QueryTables
qt.BackgroundQuery = False
next
Next


Many thanks for the info Gents - got it running perfectly now.

Cheers,

Roger