The AutoFilter actually does work on all 40,000 records. The limitation is in the number if unique items it can list in the dropdown: 10,000 which is a significant increase over Excel 2003's limit.
Does that information help?
196 people found this reply helpful
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.