Excel popup 'view cannot be displayed because it contains more data than is supported'

115 views Asked by At

I encountered a new a popup in Excel Online that I don't understand. I can't figure out the origin of the issue. The excel is built of tables, most of columns have a formula which length is about 8000 characters. All suddenly, the popup appears
enter image description here

Sorry it's in French. it might be translated into "We cannot display the content in this view because it contains more data than is supported." in English versions.

Why does it occurred? Is the data too large (up to 45 columns) for Excel Online? is the cumulated formula length to long? it seems to work well in Excel Desktop (2019 edition), but not on Excel Online in SharePoint.

I found this thread the-content-in-this-view-cant-be-displayed, which seems to deal with same issue, but no real anwser.

0

There are 0 answers