View Single Post
  #5   Report Post  
Stephen Sander
 
Posts: n/a
Default

I had the same problem. Uuse this link instead of the MSN site (which
appears to have been changed to "lock out" external queries:

http://finance.yahoo.com/q/cq?d=v1&s=["QUOTE0","Enter stock, fund or
other MS Investor symbols separated by commas."]

This is the Yahoo site...works well for me, but you'll have to update
your cell references, since it places the data in different cells.

Steve Sander


On Wed, 13 Jul 2005 09:09:05 -0700, "Festus Bola Ademorijimi" <Festus
Bola wrote:

Folks,
I am using an excel 2000, and I set up the Microsoft's saved web query
"Microsoft Investor Stock Quotes.iqy" which ran smoothly, and I was able to
refresh the data on my worksheet until some months ago when it stopped
working. I have tried setting up a new one that still would not work.
Any idea how to get this working again? I have tried rebooting my machine,
still no luck.
Here is the message which I am getting each time I tried to refresh the
query: Unable to open
http://investor.msn.com/external/exc...asp?symbol=LU+ Cannot download
the information you requested"
Note-LU is the symbol of the stock which I set up