Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to open MSN stock quote query in get external data in Exce
I have been using the external data command to import stock quotes using the
saved query that comes pre-installed with Excel. I have been using it for over three years, but recently when I open the workbook, I get an error stating "unable to open the web site Moneycentral/external/....". Then today it started working again! Was this a problem with MSN Moneycentral or was there a problem in my Excel? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to open MSN stock quote query in get external data in Exce
Interesting. So you don't need to fix anything if you wait two weeks.
You might take a look at http://www.mvps.org/dmcritchie/excel/stocks.htm#query I wasn't bitten by this as I'm satisfied, or make do with Quicken, and can look up value for any day back for several years without trying to do someting in Excel. --- 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 "jermussen" wrote in message ... I have been using the external data command to import stock quotes using the saved query that comes pre-installed with Excel. I have been using it for over three years, but recently when I open the workbook, I get an error stating "unable to open the web site Moneycentral/external/....". Then today it started working again! Was this a problem with MSN Moneycentral or was there a problem in my Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data - Stock Quote | Excel Worksheet Functions | |||
Web query - Unable to open | Excel Discussion (Misc queries) | |||
External data query leaves datasource workbook open | Excel Discussion (Misc queries) | |||
Stock Quote Add-inoffer more data (Div. Payout %, 5-YR PE AVG, | Excel Worksheet Functions | |||
stock quote lookup query for Excel 2000 | Excel Worksheet Functions |