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.
↑ Back to the top
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.
↑ Back to the top
Microsoft has confirmed that this is a bug in the Microsoft
products that are listed at the beginning of this article.
↑ Back to the top
As a result, a different table may be imported into Excel
than the one that was selected in the Web Query dialog
box.
↑ Back to the top