Insert issues in Excel - Read more

This troubleshooting article explains why you are seeing the following error message:

Below is a list of scenarios that could lead to the insert error:

• Merged cells
• Invalid selection (selecting >1 cell)
• Locked cells
• Protected sheet/workbook
• Losing focus on the worksheet: select cell, change sheet, then select insert
• Server error (operation failed)