Excel crash after updating cell value

An Excel 'Crash to Desktop' can occur in certain circumstances when updating a cell and exiting it by pressing 'Enter' or moving a mouse key. It occurs most frequently when updating the 'Reconcile To' fields and 'Status' update on the Index page in workpapers where there are multiple workpapers under a single account.


The issues arise from some Excel features, being flash fill and quick analysis, which are unstable. If they cause frequent issues, we suggest the following workaround which will improve stability:


1. Click on File --> Options --> Advanced.

2.In the Editing Options section, clear the checkbox for Automatically Flash Fill.

3.Click on the General tab.

4.Clear Show Quick Analysis options on selection.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.