Cannot Insert an Object in Excel – 5 Solutions

The 2021 Quarterly Sales Data showcased in B4:F14 contains the Location, and the four Quarters.

You want to insert an object and Excel shows the message “Cannot insert object”.

cannot insert object in excel

 


Solution 1 – Unprotect the Workbook

Steps:

  • Go to the Review tab >> click Protect Workbook>> Enter the password >> Click OK.

Unprotect Workbook

 


Solution 2 – Change the Macro Security Settings

Steps:

  • Go to the Developer tab >> click Macro Security.

Change Macro Security Settings

The Trust Center wizard opens.

  • Click Enable VBA macros >> Click OK.

fixing cannot insert object in excel by changing macro settings

Read More: [Fixed!] Cannot Insert PDF into Excel


Solution 3 – Obtaining a Copy of the Corrupted File

Steps:

  • Copy the dataset in the corrupted workbook by pressing CTRL + C.

Obtain a Fresh Copy of the Corrupted File

  • A new workbook will open>> Press CTRL + V to paste the data.

fixing cannot insert object in excel by copying and pasting data into new workbook

Read More: How to Insert an Excel File into Another Excel File


Solution 4 – Delete Obsolete Extenders

Steps:

  • Close all Microsoft Office applications >> press WINDOWS + R >> Enter %temp% in Run >> Click OK.

Deleting Obsolete Extenders

  • Enter .exd in the search bar >> select the file with the .exd extension and delete it permanently.

fixed cannot insert object in excel by removing exd files

  • Restart your computer.

Note: If you insert Active X Controls, the .exd files will reappear and you’ll have to remove them as described in the above procedure.


Solution 5 – Repair the Microsoft Office

If the problem persists, you can contact Microsoft Support.


What to Do If you Cannot Insert an Object in Excel VBA

Steps:

  • Press WINDOWS + R >> enter %temp% in Run >> click OK.

What to Do If Anyone Cannot Insert Object in Excel VBA

  • Search the .exd files in the search bar >> delete them permanently.

fixing cannot insert object in excel VBA

Read More: How to Attach Screenshot in Excel


Download Practice Workbook


Related Articles


<< Go Back to Attach File in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

2 Comments
  1. Thank you for sharing these solutions! I was really struggling with the “Cannot Insert an Object” error in Excel, and your step-by-step guide made it easy to follow. The registry edit solution worked perfectly for me. I appreciate the clarity and detail in your explanations!

    • Hello,

      You are most welcome. Thanks for your kind words. Glad to hear that the registry edit solution worked perfectly for you. Keep learning Excel with ExcelDemy!

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo