Excel Add-in 3.2 displays Refresh failed error after refreshing worksheet/workbook

[xiangxin_tan]

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

Issue

After importing data into Excel successfully from a module which goes over 2^31 (2,147,483,648) cell count, Excel Add-in Version 3.2 will display Refresh failed error after refreshing worksheet/workbook.

Refresh failed for worksheet

Refresh failed for workbook

 

Workaround

Reduce 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-2473

[CharlesBowman · Accepted solution]

This has been fixed in V3.3 of the Add-in