Cannot filter more than 10,000 rows

I have 40,000 rows of data in an Excel spreadsheet but am having trouble filtering the data. It stops at 10,000 rows.
Answer
Answer

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.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 25, 2024 Views 35,417 Applies to: