Knowledge Base |

# XL: "Not Enough Memory" or Computer Hangs with AutoFilter

PSS ID Number: Q105322

Article Last Modified on 03-21-2001

The information in this article applies to:

- Microsoft Excel for Windows 5.0, 5.0c
- Microsoft Excel for the Macintosh 5.0, 5.0a
- Microsoft Excel for Windows 95 7.0

## Summary

When 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"). The limit has been increased to 1000 in later versions of Excel.

Additional query words: crash respond limit max maximum drop down items limitation auto filter autofilter

Keywords: kberrmsg
Issue Type:
Technology: kbHWMAC kbOSMAC kbExcelSearch kbExcel95 kbExcel500 kbExcel95Search kbExcelMacsearch kbExcel500Mac kbExcel500aMac kbExcel500c kbExcelWinSearch