Forum Discussion
Excel filter issues
Sergei, the Excel version 1706 has a known problem with filters. It has been reported to the Excel developers. Search filters will not help in this scenario, because Excel does not include some date ranges in the filter in the first place. The search only searches in what the filter already includes. If the filter does not include it, it cannot be discovered by search.
Another couple workarounds could be
1) Use search filter
2) Convert data to table and use the slicer, for this particular case it's not too big
Sergei, the Excel version 1706 has a known problem with filters. It has been reported to the Excel developers. Search filters will not help in this scenario, because Excel does not include some date ranges in the filter in the first place. The search only searches in what the filter already includes. If the filter does not include it, it cannot be discovered by search.
Ingeborg, perhaps on some concrete builds. I'm on 1706 and search workaround works with me.
And for 10,000 limit same Microsoft gives https://support.microsoft.com/en-us/help/295971/not-all-items-are-displayed-in-the-autofilter-pivottable-list
We're still gathering reports on which versions and builds show the problem.
It may be just a few builds of the 1706 version, not all of them.
Sergei, I can confirm that the workaround you posted does not resolve the issue when it occurs. You can see in the attached screenshot that the filter does not find the dates, even though they are present in the column. You may not be able to reproduce the issue, but that does not mean that it doesn't exist for others.