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)
When using excel since the May 30th update, Excel does nothing when inserting/deleting rows/columns.
The insert and insert paste row/column options are not greyed out on right click. When the insert option is selected, nothing happens. Same for the Insert sheet rows/columns in the home tab: nothing happens when clicked. No error messages either, it seems like excel just forgets what you told it to do.
This is happening on newly opened blank workbooks as well, so there are no frozen panes, sheet protection, hidden rows, worksheet errors or corrupt workbooks, and there's no point in restarting excel for a workbook that was just opened.
I have already repaired and re-installed office 365.
Restarting the computer allows me to insert rows/columns 2-3 times before it breaks again.
EDIT: added "deleting" and "columns" to initial "could not insert rows"
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.
New version has been released. You may update to newest version.
Release notes for Current Channel releases - Office release notes | Microsoft Learn
I am having the same issue. It has only started doing it recently. I try to insert or delete a row, and sometimes it works, other times it just does nothing, also no error message or anything. If I just keep trying, eventually it works, but its only after repeating the action about 6 or 7 times then suddenly it will insert a row, but then will stop again after that and I have to try again multiple times.
I have received several files with same issue. Some files will work again after 30 seconds. Hope Microsoft will fix it soon.
I have had exactly the same issue, starting about the same time of May 30th. I have to shut down and restart Excel and then maybe it is good for 2 or 3 "insert row" or "insert paste row" before it fails to respond again.
Recently, some users also reported a similar situation. I'd suggest you create a support ticket 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