Autofilters not working

[Kim Rees]

Any idease why an autofilter should stop working after
2475 entries around the m or n area. Any ideas would be
grafefully received.

 

[Paul B]

Kim, the AutoFilter dropdown list will only show 1000 unique entries, if
this is the case have a look here for a workaround

http://www.contextures.com/xlautofilter02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Tod]

Make sure your range for autofilter includes all of the
data. If there are spaces in your data, you'll need to
highlight the data you want to autofilter in order to
include all of it.

tod