Cannot insert content of PDF in document

Steve Bayliss

New Member
Joined
Jan 13, 2016
Messages
8
Hi All,

This is actually a problem that is effecting not just Excel but all office.

I am trying to embed the content of a PDF into the workbook - I totally understand that I will only get the first page of the document, thats all I want as the PDF is always one page in length.

I am using Insert / Object, Create from File, Browse and select PDF, I DO NOT check the boxes Link to File or Display as Icon.

The result is I get an icon displayed and not the content of the PDF. This use to work fine.

The icon can be double clicked and the object will open fine.

When the icon is selected the formula bar displays =EMBED("Packager Shell Object","")

I am using Windows 7 / Office 2013

Others computers in the organisation are having the same issue but then some are OK.

The computer has Acrobat Reader DC, PDF X-Change editor and PDFCreator installed.

I have changed the default program association for PDF to Acrobat Reader and PDF X-Change but still the same results.

I have tried to turn off a number of security settings in Acrobat and PDF X-Change to no avail.

I don't have admin rights so I can't install or uninstall anything.

So, any idea anyone???

Regards

Steve
QLD Australia.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Steve Bayliss

New Member
Joined
Jan 13, 2016
Messages
8
Hi,

??? I don’t want a clickable icon, I want the content. Regardless of the whether I click ‘Display as Icon’ I always get just an icon.

Steve.
 

rlv01

Well-known Member
Joined
May 16, 2017
Messages
756
I have full admin rights, and my PC behaves the same way. I think you may be looking at taking a screen grab of the PDF doc and pasting it in as a graphic image.
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,332
maybe try:
Insert - Object - Create New - (select: Adobe Acrobat Document) - OK - select pdf file - Open
it will open Adobe Acrobat (close it) and you should see pdf file embeded in excel sheet.

see link: pdf embeded in excel sheet
 

Steve Bayliss

New Member
Joined
Jan 13, 2016
Messages
8
Hi,

Thanks for your reply. Yes, I had tried that earlier as a test and it does work. Unfortunately, I need the process to be automated so I can’t use that technique. It is all very strange as this use to work well.

Hopefully I will eventually work out the issue as there are still a few pc’s where it is working but I can it is going to a painful trial and error process to track it down and was hoping someone had already experienced the problem.

If I work it out I’ll surely post what I discover.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,332
it won't work if you want embed pdf second time (after deleting first embeded object) but I didn't check it too much.
to automate this try vba - but I don't use vba and I can't help

good luck :)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,145
Messages
5,466,935
Members
406,511
Latest member
markflayd

This Week's Hot Topics

Top