This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Has there been a new update that is causing a bug where I can not delete or insert new rows? Anytime I try to do that, it will clear the contents in the column and not delete the row. Then my Excel will crash. My colleagues are having the same issue. It started two days ago. We have tried restarting and updating Excel and nothing seems to work. Any ideas?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I had to reach out to IT/Microsoft. They have no idea what the problem is and are trying to figure it out. Thanks for trying to help, appreciate it
That's not an option as it is with all my Excel workbooks and they all need to keep the formatting.
As workaround, you may try setting calculation option to manual.
I'd suggest raise it to Microsoft.
Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.
Get support - Microsoft 365 admin | Microsoft Learn
About how to find the admin in your organization, you can refer to How do I find my Office 365 admin
You may try clearing formatting for that worksheet.
Select entire worksheet, clear formats.