Web queries return ??? in table field in Excel 98 for the Mac (186068)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
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.

REFERENCES

For more information about web queries, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

web, queries

and then click Show Topics. Select the "Get data from a Web source" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:7/13/2005
Keywords:kbbug kbpending KB186068
©2004 Microsoft Corporation. All rights reserved.