Forum Discussion
Web Query not refreshing updated data from website
Riny_van_Eekelen https://www.wellingtonairport.co.nz/flights/?direction=departure
Dezmond95 Two arriving flights just had a status change and one disappeared from the table.
NZ457 initially had "Landed 21:18". A few minutes later it updated to "Arrived at Gate".
NZ459 was still in the air when I created the macro, thus no status. It landed 21:34 though the website took 12 minutes to show it. The query still doesn't pick up this one but it does reflect others.
The "First connection" info reflects the Arrival status from some approx. 30 minutes before the PQ status. So, there are updates, but it seems to be with quite some delay.
so i've just opened my old workbook and it's displaying information from over an hour ago.
but with the recent version showing arrivals, it is staying up to date, it seems to be when i reopen the document the connection seems to be lost.
are you having any issues reloading the content after closing the file?
Dezmond95 Just re-opened the file. Refreshed and now it shows this for arrivals.
See attached. The file still has the status before a Refresh
- Has your query, refreshed to show the new days flights, mine is stuck from yesterdays point.