Hi,

I'm running this as a part of a large code set i Excel.

'   Update all data
    ActiveWorkbook.RefreshAll

'   Update data feed
    Sheets("Energy - Data Feed").Select
    Selection.QueryTable.Refresh BackgroundQuery:=False
    
'   Update data feed
    Sheets("Commodities - Data Feed").Select
    Selection.QueryTable.Refresh BackgroundQuery:=False
However the macro fails at the first "Selection.QueryTable.Refresh BackgroundQuery:=False". At what seems random. As it works sometimes, and other times not..

Is there a more reliable way to update an external website datafeed?