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
Solved! Go to Solution.
This issue has been fixed in version 3.3 of the Add-in