Highlighted
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

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