Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web queries in Excel 2003 not working at all
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/s...ote?Symbol=aig or http://moneycentral.msn.com/investor...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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web queries in Excel 2003 not working at all
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 --- 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 "CDA" wrote in message ... 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/s...ote?Symbol=aig or http://moneycentral.msn.com/investor...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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove default data path for sql queries excel 2003? | Setting up and Configuration of Excel | |||
Excel 2003 randomly loosing database queries | Excel Discussion (Misc queries) | |||
Queries from Excel 2003 to Access | Excel Discussion (Misc queries) | |||
problem with excel 2003 queries | Excel Discussion (Misc queries) | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) |