Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Embedding PDFs to Excel 2016 Mac

Posted on 2016-09-19
6
77 Views
Last Modified: 2016-10-16
Hi,

I am running Excel 2016 for Mac version 15.26 and Adobe Acrobat Pro DC version 2015.017.20053

I am trying to insert PDFs by going to Insert -> Object -> From file -> and I receive the following warning:

Alert " Can not insert object"

Both softwares are up to date. I have tried with different PDFs and the problem persists.

Please advise.

Thanks
0
Comment
Question by:Rod_2012
  • 3
6 Comments
 
LVL 53

Assisted Solution

by:strung
strung earned 250 total points
ID: 41805409
According to:  http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/excel-2010-cannot-insert-object-when-linking-to-a/45622d13-f742-4564-a25a-a24b97fdf0dc

"This is a known issue, Please try the following workaround
1) Insert PDF file using Insert -> Object -> Create New - Package [This will give you an option to select a pdf on any network path]
OR
2) Insert -> Object -> Create from file [Select the network path & file] and select Display as Icon"
0
 
LVL 14

Accepted Solution

by:
Schnell Solutions earned 250 total points
ID: 41805415
Hello,

You can make it in Office 2016 for Windows but you cannot in Office 2015 for Mac (which is the last version). It does not allow you to insert PDFs with the option Insert ---> Object --- > etc.

One workaround is to insert the PDF file as a picture (However, it will just add you one page at a time). Sounds strange, but yes... You can click:

Insert --> Picture --> Picture from File --> Then look for your file (Sometimes you need to specify that it adds all kind of files in the options if it is not set to do so). As far as the Mac cannot represent an icon on the spreadsheet it will show you the page of the PDF file as an image (if there are many pages just the first).
0
 
LVL 14

Expert Comment

by:Schnell Solutions
ID: 41805421
Hello Strung, I am afraid that these options were available in Office for Mac 2010, but not in 2015 anymore, which is the version or Rod.

And the import options that are available from the File menu are just... CSV, FileMaker, HTML or a Text file.

Another long and very inefficient option would be to add it as an hyperlink... something like saving the pdf somewhere in the network and then invoking it from there (which sounds crazy).
0
 

Author Comment

by:Rod_2012
ID: 41805483
Thank you for your comments.

Schnellsolutions, I can see the option to insert picture, but one page solution does not help me here.

I am now trying to achieve the same via Windows 7, Office 2016 and it works fine.

I guess a update should fix this in the future.
0
 
LVL 14

Expert Comment

by:Schnell Solutions
ID: 41805782
Yeap, it usually does not achieve the desired purpose. But some people make it braking the PDF in multiple images and then loading it into office (which is not efficient).
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Adobe PDF proprietary file format is recognized as secure and formulated. But these PDF files are also prone to corruption and any external threat like virus attacks, improper storage can hit PDF file integrity.This type of damages can make cruc…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question