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.

Question Info

Last updated June 3, 2020 Views 31,658 Applies to:

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.)

Ron Coderre
Microsoft MVP - Excel

195 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.