Forum Discussion
Excel online - Issue with easy filtering
Did you apply filter to entire columns or to some range?
thanks for replying.
I tried both actually (and even more, probably):
- filter applied to entire columns
- filter applied to the range only
- filter applied not selecting anything first, just one cell into the row 1
Always the same result...
Thank you for the details. I also see such alert first time, tried to reproduce but can't. The only some issues if select entire columns, but bit different ones.
I am running even more tests. It actually looks like Excel online has a limit in terms of data which can be display, which sounds crazy indeed. I have tried deleting random blocks of columns and/or rows and it looks like the filter is not able to work anymore when over a certain amount of data is in the sheet!
This is driving me crazy, how could such a low amount of data reach any limit, if still a limit exists?
I would really love to know more about that. Not to mention I need this simply sheet to work 😐Afraid that's something else. I tested on 100 000 rows x 75 columns sheet, it works.