Filter limit in Excel
yfchauer
Posted messages
84
Status
Membre
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Good evening everyone,
I have an Excel file with more than 25,000 rows, and when applying a filter, it indicates that it can only display the first 10,000 rows.
I want to know if there is a method to display all the rows in the filter, and if so, how can I do it?
Thank you in advance for your help
Configuration: win xp home
--
Ambition is like riding a bike. Once you stop pedaling, you fall.
I have an Excel file with more than 25,000 rows, and when applying a filter, it indicates that it can only display the first 10,000 rows.
I want to know if there is a method to display all the rows in the filter, and if so, how can I do it?
Thank you in advance for your help
Configuration: win xp home
--
Ambition is like riding a bike. Once you stop pedaling, you fall.
2 réponses
Hello,
The Excel filter "can only display the first 10,000 rows" is like your car that only has 5 seats: it's made that way and you have to deal with it.
If you want to filter beyond that, you need to program the function in VBA and it's not certain you'll wait for the 25,000 rows because you'll have to program it in detail.
--
Always zen
Perfection is attained not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
The Excel filter "can only display the first 10,000 rows" is like your car that only has 5 seats: it's made that way and you have to deal with it.
If you want to filter beyond that, you need to program the function in VBA and it's not certain you'll wait for the 25,000 rows because you'll have to program it in detail.
--
Always zen
Perfection is attained not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
