Highlighted
Contributor
Contributor

Excel Add-on 3.4: Excel crashes whilst using “Show Changes” on a read-write multi-sheet connection

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

 

Issue

Excel crashes when using “Show Changes” on a read-write multi-sheet connection if:

  1. The user enters invalid cell value on a sheet
  2. Clicks onto “Show Changes”
  3. Cycles to a different sheet/tab
  4. Cycles between sheets on the “Show Changes” drop down
  5. Clicks “Send and Refresh”

Excel will immediately restart and any functionality after this point will not work until Excel is re-booted.

 

Workaround

Do not cycle between both tabs and the drop down while the “Show Changes” pop up is open.

 

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

 

---

Internal Reference: XLSX-2859