Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web Query Auto Refresh
I am currently using Excel 2007 and have set-up a web query using the web
query feature. I have set the query to auto refresh every minute and to refresh on open and it will not refresh. They only way I can get the information to update is by actually pushing the refresh button. I need this to be a fully automated task. The website I have linked to is: http://xml.weather.yahoo.com/forecastrss?p=USWV0507&u=f |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web Query Auto Refresh
I haven't upgraded to Excel 2007 yet, but I suspect this may do what you want:
http://www.cpearson.com/excel/OnTime.aspx Regards, Ryan--- PS, that web site is awesome! You will learn a lot of useful/practical things on there... -- RyGuy "sjgillum" wrote: I am currently using Excel 2007 and have set-up a web query using the web query feature. I have set the query to auto refresh every minute and to refresh on open and it will not refresh. They only way I can get the information to update is by actually pushing the refresh button. I need this to be a fully automated task. The website I have linked to is: http://xml.weather.yahoo.com/forecastrss?p=USWV0507&u=f |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Web Query Auto Refresh
Thanks, I'll try some things on that website. It should work until someone
can tell me why the built in feature to refresh all on startup or with timers isn't working. I would like to keep the worksheet as simple as possible without writing code and use the built in features. I can't figure out what is making the auto-refresh not work. Thanks again for your suggestion, Jen "ryguy7272" wrote: I haven't upgraded to Excel 2007 yet, but I suspect this may do what you want: http://www.cpearson.com/excel/OnTime.aspx Regards, Ryan--- PS, that web site is awesome! You will learn a lot of useful/practical things on there... -- RyGuy "sjgillum" wrote: I am currently using Excel 2007 and have set-up a web query using the web query feature. I have set the query to auto refresh every minute and to refresh on open and it will not refresh. They only way I can get the information to update is by actually pushing the refresh button. I need this to be a fully automated task. The website I have linked to is: http://xml.weather.yahoo.com/forecastrss?p=USWV0507&u=f |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
How do you avoid window that prompts to enable auto query refresh | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
How do I get a web query to auto-refresh before a pivot table aut. | Excel Discussion (Misc queries) |