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 so). For some reason it looks like it's not possible to filter. The error returned is very much uncommon and I can't find anything on Google about that.
"The content in this view can't be displayed , as it contains more data than currently supported."
To better explain, I recorded the screen when filtering the sheet (just few seconds to watch): https://tinyurl.com/2wms89d6
As you can see, when I try to filter, the sheet becomes unusable. If I restore the previous version and try again, I get same issue every time.
Of course this is perfectly working on Desktop.
I don't really think it's a problem with the amount of rows as 4k rows is not so much. By the way, this filtering action should leave just 20 rows or so.
Any help would be very much appreciated, thanks in advance.
7 Replies
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.
