Forum Discussion

rickburgess's avatar
rickburgess
Copper Contributor
Jun 21, 2024

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

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.

 

 

excel
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    check protection settings, workbook protection, Excel Safe Mode, updates, try different versions, rebuild Excel defaults, check file corruption, repair Office, check permissions, and reset Excel to default settings.

Resources