Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2002: "Invalid Web Query" Error Message When You Click "Refresh All"


View products that this article applies to.

Symptoms

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

↑ Back to the top


Cause

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

↑ Back to the top


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.

↑ Back to the top


Status

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

↑ Back to the top


Keywords: KB810183, kberrmsg

↑ Back to the top

Article Info
Article ID : 810183
Revision : 5
Created on : 2/1/2007
Published on : 2/1/2007
Exists online : False
Views : 196