Excel VBA Query Refresh Very Slow

[hdubitzky]

Below, I have an Excel VBA statement that takes 20 MINUTES to complete:


Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False


Versus, when I right-click the query table in the sheet and manually hit "Refresh" - it only takes 10 SECONDS to complete!


What's the deal? Is the VBA statement inadequate?

 

[DikAlex777]

Below, I have an Excel VBA statement that takes 20 MINUTES to complete:


Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False


Versus, when I right-click the query table in the sheet and manually hit "Refresh" - it only takes 10 SECONDS to complete!


What's the deal? Is the VBA statement inadequate?

you can try like this
Application.ScreenUpdating = False
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False
Application.ScreenUpdating = True


Worked for me.