Web queries in Excel 2003 not working at all

[CDA]

Hi All.

After the usual Data/Import External Data/New Web Query the window starts in
www.google.com and displays

"Action Canceled. Internet Explorer was unable to link to the Web page
you requested. The page might be temporarily unavailable."

If I enter

http://moneycentral.msn.com/detail/stock_quote?Symbol=aig
or
http://moneycentral.msn.com/investor/external/excel/quotes.asp?SYMBOL=IBM

I receive a nasty

"The page cannot be displayed. The page you are looking for is currently
unavailable. The Web site might be experiencing technical difficulties, or
you may need to adjust your browser settinngs."

However, the same query works in IE. Needless to say, I tried with other
sites, and the result is the same.

I'm using Windows XP, Excel 2003. My computer is part of a LAN, inside a SBC
Yahoo firewall. I also disabled both the Windows and the SBC Yahoo firewalls
and the results are the same: cannot connect.

Any suggestion? Do I have to change any settings? Any Office Control to
download or Office Web Components missing? How to add them?

I looked for the requirements/options/settings to make Web Query run in
Excel 2003 but couldn't find them on the Microsoft website (or anywhere
else).

Thanks guys,

CW

 

[David McRitchie]

Hi Charles,
If you don't already have your answer, there were several threads involving
web queries failing due to a change at moneycentral
http://www.mvps.org/dmcritchie/excel/stocks.htm#query