Excel Add-in 3.2: Unable to create a connection to a saved view that has cell count over 1 million

Highlighted
New Contributor

Excel Add-in 3.2: Unable to create a connection to a saved view that has cell count over 1 million

This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed.

 

Issue

In Excel 3.2 it is currently not possible to create a new connection to a saved view where the total cell count of the dimensions (rows x columns) is over 1 million. This means that any hidden line items and/or any filters applied will have no effect on reducing the view size and it will not be possible to create a new connection if the count is over 1 million. The following error message will be shown when attempting to create a new connection:

Capture.PNG

 

 

 

 

 

Workaround

Move one or more dimensions to pages until the cell count of columns x rows is under 1 million and save this as a new view. 

 

---

Internal Reference: XLSX-2476

Message 1 of 1