Occasional Contributor

Excel Add-in 3.0/3.1 does not allow module selection with over 2.1 billion cell count

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

Issue

When a module goes over 2^31 (2,147,483,648) cell count, Excel Add-in Version 3.1 doesn't allow you to select that module. 

The Next button will be greyed out.

Capture (1).PNG

 

This can also manifest itself as a 'Permission Denied' error when refreshing a connection to a module that was under 2.1 billion cells initially but the module has recently increased to over 2.1 billion cells

Workaround

This issue no longer occurs in version 3.2 of the Add-in, however it can be worked around in previous versions by reducing the module cell count to be below 2^31(2,147,483,648).

If this workaround is not suitable in your use case, please contact Support at support@anaplan.com.

 

---

Internal Reference: XLSX-892