Ron,
You probably have already checked this, but are you sure that all the data is exactly the same on the excluded records. For example one is "Smith" and the other is " Smith"? I've used the filter on much larger sheets without issue.
Good luck.
Hi Ron
I believe the issue may be to do with the range needing to be sorted. As you know when you apply auto filters it displays the list in a sorted order and cannot sort beyond a certain rows amount.
Dave
OzGrid Business Applications
> Some rows are starting to be left out of the autofilter operation. I've searched for an answer but haven't found any information on a possible limit.
Ron, if you're referring to number of entries in your AutoFilter drop down list then you should know that there is a limit -- 1000 unique entries. Your AutoFilter will function correctly if you have more that 1000 unique entries in your data list column, but you'll have to use a Custom selection or use an Advanced AutoFilter with a criteria range.