Forum Discussion
Excel online - Issue with easy filtering
Hello, I hope I may be able to get some assistance here. I have a simple sheet (Excel online), about 4,000 rows. Flat data, no formulas, no table, easy content (just descriptions, names, dates and ...
Did you apply filter to entire columns or to some range?
- Hi Sergei,
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 😐
