Why has "auto refresh web data" stopped working

**semajjames** · 01-27-2015, 10:09 PM

I have A web page feeding into excel and have set excel to refresh the data every 1 min but it is not doing it ,,,

If I press the "refresh All" button on the top tool bar it starts to refresh I see the green globe near the start button but that's all, the data does not refresh ,,, however if i go into "workbook connections" and use the refresh button there then the data updates fine but still no auto update

what can cause this ??

cheers

after pressing "refresh all" inside "workbook connections" the window need's to be closed before refresh completes ,,,

**semajjames** · 01-28-2015, 09:07 AM

Update ,,, i use this code in my workbook ,,,, the code is interfering with refresh

when I have the code running then refresh does not work but if I pause/break the code then refresh work's as normal

Sub RealTimeGraph()

starttime = Int(Timer)
Do
If Timer - starttime > 300 Then
Application.Workbooks("Book1.xlsm").Sheets("Sheet2").Range("B" & Rows.Count).End(xlUp).Offset(1) = _
Application.Workbooks("Book1.xlsm").Sheets("Sheet1").Range("a1")
Application.Workbooks("Book1.xlsm").Sheets("Sheet2").Range("C" & Rows.Count).End(xlUp).Offset(1) = _
Application.Workbooks("Book1.xlsm").Sheets("Sheet1").Range("a2")
starttime = Int(Timer)
DoEvents
Else: DoEvents
End If
Loop While Application.Workbooks("Book1.xlsm").Sheets("Sheet2").Range("B400") = ""

End Sub

**semajjames** · 01-29-2015, 01:54 PM

I have found this ,,, only thing is my query is not part of the code ,,,,,
could it be causing this problem ?

NOTE While you are recording a macro that includes a query, Excel does not run the query in the background. To change the recorded macro so that the query runs in the background, edit the macro in the Visual Basic Editor. Change the refresh method for the QueryTable object from BackgroundQuery := False to BackgroundQuery := True.