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?
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?