XL97: Cannot Use Edit Query Button on Sheet With Web QueryLast reviewed: January 15, 1998Article ID: Q158247 |
The information in this article applies to:
SYMPTOMSWhen 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 editedand your only option is to click OK.
CAUSEYou 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.
RESOLUTIONTo edit your Web query, you need to open the .iqy file you created for the Web query using a text editor like Notepad.
STATUSThis is by design of Microsoft Excel 97.
MORE INFORMATIONLike 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:
WEB 1 http://webservices.pcquote.com/cgi-bin/exceldow.exe?NOTE: This is a "Get" query because the fourth line of text is not used.
For additional information, please see the following article(s) in the Microsoft Knowledge Base:
ARTICLE-ID: Q157482 TITLE : XL97: How to Create Web Query (.iqy) Files REFERENCESFor more information about Web Queries, click the Index tab in Microsoft Excel 97 Help, type the following text
web, queriesand then double-click the selected text to go to the "Get data from a Web source" topic.
|
Additional query words: 8.00 XL97 www http htm internet intranet
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |