I also have problem in autofilter, I used excel 2003. I have tried the solution above but it still not working properly.
I am working on an excel file that have approximately 3000 rows and 30 collumns and using autofilter..
The autofilter not working properly for some collumn but working for other collumns.
For example for collumn A I have 3000 rows with maybe around 1000 different items (some is duplicated with different input in other collumns), when I try to use the drop down list in collumn A, the list is not showing all the item available in collumn A (eg 'AAA').
But when I filter collumn B (eg 'BBB'), then I want to filter again using column A, the items 'AAA' appears in the drop down list.
The question is why the items 'AAA' not appear in the drop down list when I haven't filtered other collumns first?
Please help, your reply is greatly appreciated.