Insert/Delete Sheet Rows/Columns no longer working in new release of Excel

Copper Contributor

I recently bought a new Windows 11 PC to replace a boat anchor Windows 7 box.

Windows 11 box has most recent version of MSO365/Excel. 


An Excel doc from the old PC loads and looks fine on the Windows 11 box,  however I can no longer add or delete sheet rows or sheet columns (not even in Safe Mode) using right click Insert/Delete or using 'Insert/Delete Sheet Rows or Insert/Delete Sheet Columns. The Delete Sheet row/column will clear the data, but it will not delete the row/column.


Does anyone have any insight into how to resolve this?

Recreating the Excel file would easily be a man-month of work so hoping to avoid that option.




0 Replies