XL98: Web Queries Return ??? in Table Field

ID: Q186068

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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://investor.msn.com/external/excel/quotes.asp?
      SYMBOL=.MSQDD,.INQDT,.CLHI,.MERTK

Modified web query text:


   WEB
   1
   http://investor.msn.com/external/excel/quotes.asp?
      SYMBOL=.INQDT

Microsoft Investor Currencies

Original web query text:


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

Modified web query text:


   WEB
   1
   http://investor.msn.com/external/excel/quotes.asp?
      SYMBOL=/ADY,/BPY,/CDY,/ZEY,/DMY,/SFY

Microsoft Investor Indices

Original web query text:


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

Modified web query text:


   WEB
   1
   http://investor.msn.com/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.

MORE INFORMATION

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.

Additional query words: XL98 html internet

Keywords : kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug