excel embedded pdf error cannot start the source application for this object

Finance opens a lot of .xls's with embedded pdf's.  They get error,  cannot start the source application for this object
The eu's are using Nitro Pro
Any help is appreciated.
Mark O'BrienDispatch Software Support and Server AdministrationAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Mark,

Sounds to me as if the embedded object has an "Opens with" Adobe Reader, not Nitro Pro. Furthermore, the error your users are getting is often caused by the Adobe Reader setting of "Enable Protected Mode at startup".

So, first thing is to check one of the embedded PDFs, as follows:

Right-click on the PDF icon in the Excel spreadsheet
Packager Shell Object Object
Properties
General
Look at the "Opens with"

If it's Adobe Reader, click the Change button, select Nitro Pro, and see if that works.

You could also try this. Leave it as Adobe Reader, but do this in Reader — there are slightly different steps for Reader X and XI.

Reader X:
Edit
Preferences
General
Un-check "Enable Protected Mode at startup"

Reader XI:
Edit
Preferences
Security (Enhanced)
Un-check "Enable Protected Mode at startup"

Regards, Joe
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Hi Joe, thanks.
The embedded Nitro 10 pdf shows up as an actual pdf file you can read.  I guess it's the first page of the pdf.  If I r-click that, I dont get a Properties in the menu
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Mark,

Your spreadsheets with embedded PDFs should look something like this:

spreadsheet embedded PDFs
When you right-click on the icon of one of the embedded PDFs, you'll get a context menu like this:

context menu
When you select Properties, you'll get this dialog:

Properties of embedded PDF
What are you seeing when you do that?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
the first actual page of the PDF is showing up in the Excel spreadsheet
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Ah, I'm used to embedding as an icon:

embed display as icon
Seems that your folks have that un-checked. When I un-check it, I get the first page embedded and a right-click on it gives this context menu:

context menu first page
What does yours look like?
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Joe, by the way this is for Office 2010.  Will that make a diff?
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Maybe, but probably not. Everything I've done in this thread so far has been with Office 2013, but my general experience is that Office 2010 behaves similarly. Of course, in any particular situation, there could be a difference between the two. But I just tested this in Excel 2010 and everything I posted above is the same. Now, back to my last question: when you right-click on the first page of the embedded PDF, what is the context menu? Just post a screenshot of it.
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Any idea why that error is coming up when trying to open the embedded pdf?
0
Joe Winograd, Fellow&MVEDeveloperCommented:
> Any idea why that error is coming up when trying to open the embedded pdf?

Yes, I said it in my very first post:
Sounds to me as if the embedded object has an "Opens with" Adobe Reader, not Nitro Pro.
And with the setting of "Enable Protected Mode at startup" (which is known to cause that error message).

That's why I've asked you to post the screenshots — I'd like to see what program is set to open the PDF. If Nitro Pro is associated with PDF, then maybe it has a setting similar to the "Enable Protected Mode at startup" setting of Adobe Reader (I don't know — I have Nitro Reader installed, but not Nitro Pro). Another possibility is that Nitro Pro is not handling the automation call correctly to open the embedded PDF when invoked from Excel — I presume that Nitro Pro opens PDFs fine in other cases, such as from Windows/File Explorer.

As an experiment, you could install Adobe Reader on a test machine, make it the default program for PDFs, and then see if opening a PDF embedded in a spreadsheet works. Regards, Joe
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Nitro is set to open all pdf
0
Joe Winograd, Fellow&MVEDeveloperCommented:
When I right-click on the first page of an embedded PDF in Excel, I get this:

context menu first page
What do you get?
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I asked for help from a manager and he for some reason decided to load Adobe as well and that fixed the issue.
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Mark88's comment #a40913838

for the following reason:

self resolution
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Yes, of course loading Adobe fixes the problem, as I suggested in virtually all of my posts. The issue, I thought, was to get it to work with Nitro Pro. If you're saying that loading Adobe fixed the problem, then I think these posts deserve "credit":

http:#a40903511
http:#a40904607
http:#a40904661
http:#a40905217

In fact, note this comment in the last one above:
As an experiment, you could install Adobe Reader on a test machine, make it the default program for PDFs, and then see if opening a PDF embedded in a spreadsheet works.
Seems to me that's exactly what your manager did and you've indicated that it is the solution! I'd say, credit where credit is due. Regards, Joe
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
sorry missed that part.  my mistake
0
Joe Winograd, Fellow&MVEDeveloperCommented:
OK, thanks for the correction — I really appreciate it! Cheers, Joe
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.