Microsoft KB Archive/158247

= XL97: Cannot Use Edit Query Button on Sheet With Web Query =

Article ID: 158247

Article Last Modified on 6/12/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q158247



SYMPTOMS
When you click the "Edit Query" toolbar button on the "External Data" toolbar, you may receive the following error message:

This external data range contains data from a Web query. Web queries cannot be edited

and your only option is to click OK.



CAUSE
You cannot edit Web queries from within Microsoft Excel. The Edit Query button on the External Data toolbar is used to edit queries created in Microsoft Query.



RESOLUTION
To edit your Web query, you need to open the .iqy file you created for the Web query using a text editor like Notepad.



STATUS
This is by design of Microsoft Excel 97.



MORE INFORMATION
Like any other data query in Microsoft Excel, a Web query is a tool to extract information from a Web site and return it back to your worksheet.

A Web query is performed by doing the following:

  Create a Web query file (.iqy extension) with the following structure:    Type of Query Version of Query URL Post Parameters (not required for "Get" queries) Microsoft Office installs several sample Web query files in the \Program Files\Microsoft Office\Queries folder. The following is the text of the "Dow Jones Stocks by PC Quote, Inc.iqy" file in this folder:

WEB

1

NOTE: This is a "Get" query because the fourth line of text is not used.  In Microsoft Excel 97 point to "Get External Data" on the Data menu and then click "Run Web Query." In the "Run Query" dialog box, locate and select your .iqy file, and then click "Get Data." Based on the type of Web query file you created, you may have to specify some information for the Web query.</ol>

Your query will be performed and, if successful, the data will be returned to the location you specified.

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

157482 How to Create Web Query (.iqy) Files

<div class="references_section">