Microsoft KB Archive/186068

= Web queries return ??? in table field in Excel 98 for the Mac =

Article ID: 186068

Article Last Modified on 7/13/2005

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q186068



SYMPTOMS
When you run one of the following Web queries   Microsoft Investor Options Microsoft Investor Currencies Microsoft Investor Indices you may see ??? in some cells of the table that is returned by the query.



CAUSE
You may see ??? in some worksheet cells after running a Web query because the Web query file contains some parameters that are no longer valid.



RESOLUTION
Because the parameters that cause ??? to be returned in the table are no longer valid, you can either ignore them, or you can manually edit the Web query file to remove the parameters.

To manually edit the Web query files, open the file in a text editor such as SimpleText, make the change, (see the items below) and then save the file.

Note The third and fourth lines in each of the items below are actually a single line of text in the Web query file. They are displayed on two lines in this article because of margin limitations.

Microsoft Investor Options

Original web query text:

  WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=.MSQDD,.INQDT,.CLHI,.MERTK Modified web query text:   WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=.INQDT

Microsoft Investor Currencies

Original web query text:

  WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=/ADY,/BPY,/CDY,/ZEY,/DMY,/MPY,/SFY Modified web query text:   WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=/ADY,/BPY,/CDY,/ZEY,/DMY,/SFY

Microsoft Investor Indices

Original web query text:

  WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=$INDU,COMP,SPX,OEX,NIK,$TRAN,RUT,SOX,IIX,$UTIL Modified web query text:   WEB 1  http://moneycentral.msn.com/investor/external/excel/quotes.asp? SYMBOL=$INDU,COMP,SPX,OEX,$TRAN,RUT,SOX,IIX,$UTIL



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

