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

[CharlesBowman]

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

Issue

In Excel Add-in V3.2 and V3.3 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:

 

 

 

 

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

[CharlesBowman · Accepted solution]

This issue has been fixed in version 3.3 of the Add-in