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:
- The user enters invalid cell value on a sheet
- Clicks onto “Show Changes”
- Cycles to a different sheet/tab
- Cycles between sheets on the “Show Changes” drop down
- 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
