Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

"Cannot insert object" Error when inserting PDF files/objects into Microsoft Excel

Tags:

excel

pdf

I am currently using microsoft excel 2010. Trying to insert some PDF files into the spreadsheet.

I cliked Insert Tab -> Object -> select Adobe Document (Checked the Display as icon checkbox) from the list -> Go on to the "Create from file" tab -> Select the pdf file from my computer (Checked display as icon) -> press the OK button Then the following error appear in a dialogbox: "Cannot insert object".

Other Objects (such as other excels and words) and Pictures can be inserted without problem.

Tried the following, and did NOT help at all:

  • Reopen excel spreadsheet
  • Delete the file MSForms.exd from any Tempsubfolder in the user's profile
  • Delete all the MS Office updates
  • Delete all the files end with .exd
like image 936
Ryan Fung Avatar asked Dec 15 '15 09:12

Ryan Fung


People also ask

Why can I not insert a PDF into Excel?

If Excel displays an error message when you attempt to incorporate a PDF into your worksheet, you may have fallen afoul of an Adobe Reader Feature called Protected Mode. Designed to prevent malicious code from executing from a PDF file, this protective mode limits what PDFs can do.

Can you embed PDF file in Excel?

Open up the Excel spreadsheet that you want to place the link into and select Insert > Object. 2. Add your PDF. Click Create > Browse to locate the PDF you want to insert.


2 Answers

Finially I figured out a way to solve this PDF attachment problem on excel: Select a Package instead!

Go to Insert Tab -> Object -> double click Package in the list of options -> then the "Create Package" dialog will appear where it will guide you through the attachment process!

It even allows you to rename the file name of the attachment.

Hope it helps.

like image 128
Ryan Fung Avatar answered Sep 22 '22 07:09

Ryan Fung


Usually it is because you still open the pdf file. Make sure the pdf file you were trying to insert is closed.

like image 45
William Avatar answered Sep 22 '22 07:09

William