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.
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:
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.