Forum Discussion
Web Query not refreshing updated data from website
Dezmond95 It's going to be difficult to help if you don't share the URL.
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 Thanks. Not much happening there right now, but I've connected to the site both Arrivals and Departures and will see what happens in the next hour or so.
Riny_van_Eekelen thanks, I really appreciate you taking a look.
