Solved

Embedded PDF in Excel 2010

Posted on 2013-01-03
4
573 Views
Last Modified: 2013-01-09
I have a user with two versions of Adobe, Adobe 4 (don't ask) and Adobe 7.  The require both.  The problem I'm having is within Excel 2010.  When this user opens an embedded PDF in Excel, it chooses Adobe 4 as the viewer and editor.  How would I switch it to automatically select Adobe 7 when double clicking on an object in a spreadsheet?  I've already tried to right-click a PDF file (on the desktop) > Select Open With > and double-clicked Adobe 7 with the checkbox "always use the selected program to open this kind of file."  When I launched excel to try again it still opened in Adobe 4.

Any help would be much appreciated!
0
Comment
Question by:TinyTim85
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Rartemass
ID: 38742267
This is probably due to Protected Mode in Adobe. This is designed as a security measure but can cause issues like you are experiencing. As this was introduced last year the version 4 doesn't have it so should be opening things fine.

To check if this is on, which it usually is by default, open Adobe 7 and go to Edit > Preferences.
In the General category look for Enable Protected Mode and uncheck it. Restart Adobe 7.
0
 

Author Comment

by:TinyTim85
ID: 38743608
Only Adobe Reader X has protected mode.  The issue is with Excel 2010 opening the embedded PDF through Adobe 4.  Adobe 4 is used for an old third party application the user needs for his job function, but he has both Adobe 4 and Adobe 7.  I would like to configure Excel 2010 to open its embedded objects with the Adobe 7 application.  Currently, by default, it tries to launch the PDF with 4.  Hopefully that clarifies the issue.
0
 
LVL 18

Accepted Solution

by:
Rartemass earned 500 total points
ID: 38749558
Do you have the installation files for version 4 and 7?
If yes then you can try this either on a spare PC or on the client's PC.

-Uninstall both versions and ensure you remove all references to either verison if prompted
-Clean the registry of file associations for Acrobat. You may need something like ccleaner for this. Simply run the registry clean up after software removal and it should remove the unused file extensions

-Install version 7
-Confirm Excel opens PDF files
-Install version 4
-Test Excel again

If this fails repeat the above but with version 4 installed first.
This will help pinpoint where the setting is being applied.
0
 

Author Closing Comment

by:TinyTim85
ID: 38760335
Thanks for the solution, this put me on the right track.  I found that whichever Adobe version was installed most recently, that was the install that configured with MS Office.  So if you have Adobe 4 and Adobe 7, install Adobe 7 last to make sure MS Office applications correspond with that install.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now