Occasional Contributor

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

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



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:








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