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?
Ron Coderre
Microsoft MVP - Excel (2006 - 2010)
P.S. If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)
Regards,
Ron Coderre Former Microsoft MVP - Excel
200 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.