Dec 13 2021 10:48 AM
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.
Dec 13 2021 11:11 AM
Did you apply filter to entire columns or to some range?
Dec 13 2021 11:15 AM
Dec 13 2021 01:25 PM
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.
Dec 13 2021 03:53 PM
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 :|
Dec 14 2021 11:01 AM
Afraid that's something else. I tested on 100 000 rows x 75 columns sheet, it works.
Dec 14 2021 12:46 PM
yes it definitely looks like a bug for Excel on line. Where may I submit this request to Microsoft? Is there a way to open a ticket to them?
Thanks
Dec 15 2021 12:19 PM
That's only Help->Feedback