This was working a few days ago and now doesn't. When you try and Edit a Web
query the web query box pops up with the correct web address, but you get a
message ... "Navigation to the webpage was cancelled". The Web Query does
work as it is on automatic refresh in the background and pulls back the
correct data, I just can't edit it. I can run IE7 with the same address and
it works fine. I also cannot add a new web query as I only ever get the
default IE web page displayed.
the address is http://uk.finance.yahoo.com/d/quotes.csv?s=DGO.L&f=c1
Any ideas? I suspect an Windows automatic update has downloaded a "fix" and
broken it
Don Guillett - 13 Sep 2007 13:53 GMT
If you like, send me a workbook with examples and I will take a look

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
> This was working a few days ago and now doesn't. When you try and Edit a
> Web
[quoted text clipped - 12 lines]
> and
> broken it
KIG - 17 Sep 2007 17:32 GMT
I found a work around by bringing the value back as HTML not in a csv file.
Using
http://uk.finance.yahoo.com/d/?s=DGO.L&f=c1
instead of
http://uk.finance.yahoo.com/d/quotes.csv?s=DGO.L&f=c1
It must be a problem with opening a csv file from a web query, probably
something to do with security.
Regards to all