XL: "Not Enough Memory" or Computer Hangs with AutoFilterLast reviewed: February 2, 1998Article ID: Q105322 |
The information in this article applies to:
SUMMARYWhen you use the AutoFilter command to filter data, the resulting drop-down list of unique items is limited to 251 identifiers. If the number of unique identifiers in a list is extremely large, you may receive "Not Enough Memory" errors or your computer may stop responding (hang). NOTE: The limit for Microsoft Excel version 7.0 is 250 due to the addition of one more built-in list item ("Top 10").
|
Additional query words: 7.00 5.00 crash respond limit max maximum drop
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |