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.


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


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