View original (French)

Excel rows are limited to 10,000 when sorting and filtering.

Anny -  
madmyke Posted messages 52304 Registration date   Status Moderator Last intervention   -
Hello,

In the Excel spreadsheet, why are the rows for the filter function limited to displaying only 10,000 lines? Is there a solution to unlock this limit?

Configuration: Windows / Chrome 83.0.4103.97

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    it's the number of items in the drop-down list that is limited.
    A filter on these is fine even if there are more than 10,000 lines.

    The solution is to add a column to split the labels.

    For example, you could add one with the initial, which would give you a pre-filter that reduces the items in the main column to below the maximum of 10,000.
    eric

    --
    By continuously trying, we eventually succeed.
    So the more it fails, the more chances we have that it will work. (the Shadoks)
    In addition to the thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you.
    1
  2. madmyke Posted messages 52304 Registration date   Status Moderator Last intervention   12 485
     
    Hello

    Is it the Excel 2010 version?

    Best regards

    --
    "We swallow the flattery lie in one gulp and we drink the bitter truth drop by drop."
    0