L LPS Feb 16, 2010 #1 Is there a maximum capacity for Auto-filter in Excel 2000. All help is greatly appreciated.
D Dave Peterson Feb 16, 2010 #2 Not that I've seen. But you may want to explain your question in more detail. If the filter isn't including all the rows in the range you want filtered, I'd suggest that you turn it off, then select the range to filter, then re-apply the filter.
Not that I've seen. But you may want to explain your question in more detail. If the filter isn't including all the rows in the range you want filtered, I'd suggest that you turn it off, then select the range to filter, then re-apply the filter.
G Gord Dibben Feb 16, 2010 #3 If you're talking about the number of items seen in the dropdown.......... 1000 unique items is the limit. If you have more than that you will have to use the Custom feature. equal to or contains or whatever. Gord Dibben MS Excel MVP
If you're talking about the number of items seen in the dropdown.......... 1000 unique items is the limit. If you have more than that you will have to use the Custom feature. equal to or contains or whatever. Gord Dibben MS Excel MVP
