Excel Performance Problems

How to Fix Excel Crashes When Inserting or Deleting Rows

Camila Milosovich Oct 1, 2026 868 views

Question details

The user experiences sudden application crashes or cleared column contents when attempting to insert or delete rows in their spreadsheet.

How to Fix Excel Crashes When Inserting or Deleting Rows

Product: Microsoft Excel
Device & OS: not provided
Scenario: Modifying the structure of a spreadsheet by adding or removing rows after a recent software update.
Observed behavior: Excel unexpectedly crashes or erases column contents instead of properly executing the row insertion or deletion.

Before you start

Before modifying calculation options, verify which specific workbook is causing the issue and take note of any complex formulas, as the workaround will temporarily suspend automatic data refreshing.

Solution 1Recommended

Set Excel Calculation Mode to Manual

Since this is a known issue associated with recent updates, changing the calculation mode to Manual serves as an effective temporary workaround to prevent crashes while modifying rows.

This crash is actively being investigated by Microsoft. It often occurs because Excel attempts to recalculate the entire workbook's formatting and formulas simultaneously when a structural change (like deleting a row) is made.

By switching to Manual calculation, you prevent Excel from triggering this heavy background process, allowing you to insert and delete rows safely.

Open Excel Formulas Tab

Launch Microsoft Excel, open your affected workbook, and navigate to the 'Formulas' tab located on the top ribbon.

Access Calculation Options

Locate the 'Calculation' group on the right side of the ribbon and click on the 'Calculation Options' dropdown menu.

Select Manual Mode

Choose 'Manual' from the dropdown list. You can now try inserting or deleting rows without the application crashing.

Remember to Recalculate: While in Manual mode, your formulas will not update automatically. You must press F9 or click 'Calculate Now' in the Formulas tab to update your data after making changes.

Free Microsoft Office alternative

Try WPS Office to Avoid Unresolved Excel Crashes

If Microsoft Excel continues to crash or disrupt your workflow after recent updates, consider switching to WPS Office. It offers a highly stable Spreadsheet application that allows you to seamlessly insert, delete, and manage rows without performance hiccups.

1. Download and Install: Download WPS Office from the official website and follow the simple installation instructions.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx workbook.
3. Edit Without Crashes: Right-click any row header to safely insert or delete rows without experiencing application crashes.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Stable performance when handling large datasets and structural cell modifications.Free, lightweight alternative featuring a familiar user interface for zero learning curve.Cross-platform support for Windows, Mac, Linux, and mobile devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel crash specifically when I insert or delete a row?

This is often caused by recent software updates introducing bugs related to automatic workbook calculation, excessive cell formatting across entire columns, or conflicting third-party add-ins trying to process the structural change.

Will setting calculation to Manual affect how my spreadsheet works?

Yes, your formulas will no longer update automatically when you change cell values. You must manually force a recalculation by pressing the F9 key or selecting 'Calculate Now' to see updated results.

Is there a permanent fix for this Excel row deletion bug?

Currently, Microsoft is investigating the root cause of this specific update-related bug. You should regularly check for new Office updates (File > Account > Update Options > Update Now), as a permanent patch will eventually be released.

Excel & Data Problems