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.

Thanks.

​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.Thanks.    Read More

​