Unable to search item using filter after 10000th rows [PROBLEM]

[jjin]

Hi guys,

I have an excel workbook with nearly 20,000 rows of data.

When I try to filter an item, it won't show the result if the item that I am trying to search is located below 10,000th rows in the worksheet.

I am well aware of the fact that excel won't display items beyond 10000th rows which I have no issue with as long as I can filter items that is located beyond 10000th rows by typing their names in the search function.

Anyone has any clue why this is happening? Could that be due to the large data volume that I have on my worksheet?

Please help me...!!

Thanks in advance.

Jin

[mehmetcik]

It seems that there is a limitation.

http://excel.tips.net/T002914_Limits_to_Filtering.html

What are you trying to do?

We can filter using a macro and then there are no limitations.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).