Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Embedded PDF in Excel 2010

Posted on 2013-01-03
4
Medium Priority
?
582 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
[X]
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
  • 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 1500 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

715 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