Microsoft KB Archive/810183

= XL2002: &quot;Invalid Web Query&quot; Error Message When You Click &quot;Refresh All&quot; =

Article ID: 810183

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



SYMPTOMS
When you click Refresh All in an Excel workbook, you may receive the following error message:

Invalid Web Query



CAUSE
This issue may occur if you use a Web query on three different worksheets in the same workbook.



WORKAROUND
You can safely ignore this error message. The data in the worksheets is still updated correctly.

To avoid receiving this error message, click Refresh on the External Data toolbar instead of clicking Refresh All. However, the Refresh command refreshes the data on only the active worksheet. You must click Refresh on each worksheet in the workbook that uses a Web query.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kberrmsg KB810183

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.