Microsoft KB Archive/211622

= XL2000: Query Returns More Records Than You Specify =

Article ID: 211622

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211622





SYMPTOMS
When you return data from Microsoft Query to your Microsoft Excel worksheet, more records than you specified in the Limit number of records returned to box in the Options dialog box in Microsoft Query are returned.



CAUSE
The Limit number of records returned to option affects only the number of records to display in the data pane in Microsoft Query. This setting does not affect the number of records returned by your query.



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



MORE INFORMATION
The Limit number of records returned to option is useful if your query returns a large result set. Limiting the number of records that Microsoft Query can display in the data pane improves performance in Microsoft Query.

Additional query words: XL2000

Keywords: kbbug kbpending KB211622

-

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

© Microsoft Corporation. All rights reserved.