Forum Discussion
Web Query not refreshing updated data from website
I have been attempting to pull flight schedules from a website using Excel's web query. The initial time I requested information, I got the information back exactly how I wanted it but it appears t...
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.
Dezmond95 I attached my file earlier. When I open it now, it shows a long list of arrivals from 07:00 through 23:55
Departures don't want to update, though. Did you try my file?
- so in the file it shows the scheduled time as 2355 and estimated time as 2355, the website now displays 2355 and 2550 respectively. Does your refreshed version include that update?