Web Query Imports Data from a Table That You Did Not Select (277899)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Office Excel 2003
This article was previously published under Q277899

SYMPTOMS

When you import data by using a Web Query in the versions of Microsoft Excel that are listed in the "Applies to" section, your query imports data from a different table than the one that you selected in the Web Query dialog box.

CAUSE

The table that you selected in the Web Query dialog box is a dynamically scripted table. You cannot import data from dynamically scripted tables with Excel Web Queries.

STATUS

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

MORE INFORMATION

As a result, a different table may be imported into Excel than the one that was selected in the Web Query dialog box.
Modification Type:MinorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB277899
©2003 Microsoft Corporation. All rights reserved.