Excel 365 online Autofilter limit to display/ filter 1130 lines

%3CLINGO-SUB%20id%3D%22lingo-sub-2291186%22%20slang%3D%22en-US%22%3EExcel%20365%20online%20Autofilter%20limit%20to%20display%2F%20filter%201130%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291186%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20fiter%20some%20lines%20of%20a%20really%20not%20long%20document%20with%20less%20than%203000%20entries.%3C%2FP%3E%3CP%3EWhen%20I%20apply%20the%20autofilter%20it%20alwaysws%20shows%20me%20the%20warning%3A%3CBR%20%2F%3E%3CSPAN%3ENot%20all%20items%20showing%20With%20the%20Warning%20sign.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20did%20reapply%20the%20autofilter%2C%20put%20the%20filter%20in%20another%20hight%20in%20(line%201130)%20even%20though%20the%20limit%20continues%20to%20be%201130%20rows%20that%20are%20being%20displyed%20in%20the%20filter%20options.%3CBR%20%2F%3EWhen%20I%20scroll%20down%20I%20can%20see%20al%20entries%2C%20but%20I%20cannot%20use%20the%20autofilter%20which%20would%20be%20a%20great%20help%20for%20my%20task.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20on%20how%20to%20get%20in%20working%3F%3CBR%20%2F%3EThanks%20for%20your%20help%20already.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2291186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2291239%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20online%20Autofilter%20limit%20to%20display%2F%20filter%201130%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291239%22%20slang%3D%22en-US%22%3EThe%20reason%20is%20In%20Excel%202003%2C%20the%20%E2%80%9CAutoFilter%E2%80%9D%20Dropdown%20list%20shows%20the%20first%201K%20unique%20items.%20If%20you%20have%20more%20than%20a%20thousand%20unique%20items%20in%20the%20list%2C%20only%20the%20first%201k%20items%20appear.%3CBR%20%2F%3E%3CBR%20%2F%3EWorkaround%3CBR%20%2F%3EYou%20can%20use%20the%20%E2%80%9CAutoFilter%E2%80%9D%20command%20on%20several%20smaller%20sections%20of%20the%20data%20instead%20of%20on%20all%20the%20data%20at%20the%20same%20time.%20All%20the%20list%20items%20will%20be%20visible%20if%20each%20subset%20has%20no%20more%20unique%20members%20than%20the%20limit%20for%20the%20particular%20version%20of%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20Excel%202010%20and%20higher%20have%20a%20Search%20feature%20which%20was%20added%20to%20the%20Filter%20Dropdown%20list%20which%20allows%20the%20user%20to%20use%20search%20to%20display%20records%20that%20are%20not%20in%20the%20first%2010%2C000%20unique%20items.%3CBR%20%2F%3E%3CBR%20%2F%3EOther%20than%20this%2C%20if%20you%20face%20any%20kind%20of%20.xls%20or%20.xlsx%20file%20corruption%20in%20Excel%20you%20can%20check%20out%20this%20reference%20%5B%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2FLync%2Fen-US%2Fe5692c4a-924d-44a5-985b-7878f3eb26de%2Fcorrupted-excel-file-repair%3Fforum%3Dexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2FLync%2Fen-US%2Fe5692c4a-924d-44a5-985b-7878f3eb26de%2Fcorrupted-excel-file-repair%3Fforum%3Dexcel%3C%2FA%3E%5D%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2291264%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20online%20Autofilter%20limit%20to%20display%2F%20filter%201130%20lines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291264%22%20slang%3D%22en-US%22%3EHello%20Zorro_OP123%3CBR%20%2F%3Ethank%20you%20for%20your%20reply.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20using%20online%20excel%20365.%20The%20autofilter%20shows%20me%20exactly%201002%20unique%20items.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20attached%20a%20photo%20(screen%20shot)%20of%20the%20filter%20and%20there%20is%20no%20search%20feature.%3CBR%20%2F%3ESo%20unfortunately%20this%20does%20not%20help%20me%20so%20far.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to fiter some lines of a really not long document with less than 3000 entries.

When I apply the autofilter it alwaysws shows me the warning:
Not all items showing With the Warning sign.

 

I did reapply the autofilter, put the filter in another hight in (line 1130) even though the limit continues to be 1130 rows that are being displyed in the filter options.
When I scroll down I can see al entries, but I cannot use the autofilter which would be a great help for my task.

Any ideas on how to get in working?
Thanks for your help already.

2 Replies
The reason is In Excel 2003, the “AutoFilter” Dropdown list shows the first 1K unique items. If you have more than a thousand unique items in the list, only the first 1k items appear.

Workaround
You can use the “AutoFilter” command on several smaller sections of the data instead of on all the data at the same time. All the list items will be visible if each subset has no more unique members than the limit for the particular version of Excel.

The Excel 2010 and higher have a Search feature which was added to the Filter Dropdown list which allows the user to use search to display records that are not in the first 10,000 unique items.

Other than this, if you face any kind of .xls or .xlsx file corruption in Excel you can check out this reference [https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupte...]
Hello Zorro_OP123
thank you for your reply.

I am using online excel 365. The autofilter shows me exactly 1002 unique items.

I attached a photo (screen shot) of the filter and there is no search feature.
So unfortunately this does not help me so far.