stock quote query mal-function

J

jt

i have been using the 'ms investor stock quotes' function in excel 2000 to
update my portfolio; it no longer functions rather gives me this message
"Unable to open http://investor.msn.com/external/excel/quotes.asp?SYMBOL=.
Cannot download the information you requested." was working fine before i
installed explorer 6 sp1 kb883939 security update - can anyone offer a
work-around to restore functionality, or a way to un-install the security
update?
thanks for your assistance, jt.
 
J

jt

dave...thanks very much, the sheet works again after only a modest change as
per your suggestion...again thanks and be well, jt

David McRitchie said:
See Jason's reply (first reply) in this thread
http://google.com/groups?threadm=1120859768.199048.280220@g14g2000cwa.googlegroups.com

Microsoft changed the name of the URL within the query, nothing to do with IE or Excel or security
patches.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


---

jt said:
i have been using the 'ms investor stock quotes' function in excel 2000 to
update my portfolio; it no longer functions rather gives me this message
"Unable to open http://investor.msn.com/external/excel/quotes.asp?SYMBOL=.
Cannot download the information you requested." was working fine before i
installed explorer 6 sp1 kb883939 security update - can anyone offer a
work-around to restore functionality, or a way to un-install the security
update?
thanks for your assistance, jt.
 
D

David McRitchie

Thanks, good to get feedback, the problem just started popping up all over the place
after that thread. Jason's anonymous posting in that thread was the one with the
answer to change the URL within the query. I've tucked the answer away on my
http://www.mvps.org/dmcritchie/excel/stocks.htm#excerpts page though I don't

do any of that, Quicken suits me just fine. But for those that do they might
be interested in the Microsoft templates -- haven't figured out if it is possible
to search with anything like the precision of using Google to just get the
investment Excel templates, but who knows maybe someone also wants the
word templates as well..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top