I have 47000 rows of data where one of the column has around 25000 unique values.
Even if there are only 20 or more data in the filter, I almost never scroll to tick/untick the data I want to filter in/out,
most of the time I just type it in the search box then if the search result is more than one then I do the tick/untick.

Today after I type in the search box, it show me "searching".....
this is the first time experience of me that Excel is "searching" in the filter...
so I wait wait wait... but it never show up the data I type.

I notice that at the bottom of filter box a text "not all items showing"
and after I click that text, it gives me an information window that in this column has more than 10000 unique values.

So I look in the internet about this situation,
but the solution is always the same, which is "just type in the search box",
while my problem in fact is that even "just type in the search box" causing Excel to show the "searching" forever.
(well actually it's not forever as I wait only for about 5 minutes then I cancel it, not patien enough to wait longer ).

Since it seems that "just type in the search box" will solve the problem of ""not all items showing" to other users,
I wonder why it doesn't work for me.

After I scroll down the filter list to the bottom, I saw the last data shown is "P-18120705".
I assume this data is the 10000th data of the unique values.
Since the data value is in consecutive number, so my "P-18120706" data will be the 10001th unique value, and "P-18120707" is the 10002nd unique value.
So I type "P-1812070" ---> Excel show the result from "P-18120700" until "P-18120706" but not "P-18120707" and the rest.
After I continue typing number "7" (so it become "P-18120707"), then here it goes again... showing "searching" forever.

How do I solve this problem ?
Is there a setting that I can enable Excel to not searching so long to filter the data I type ?

Any kind of respond would be greatly appreciated.
Thank you in advanced.

Excel 2010
Ryzen 5 2400G
8 gb RAM
A320M mobo
Integrated GPU
Win 10 64 bit OS and Excel program on 120gb SSD