Saving Excel Hyperlinks to PDF

F

fullnelson

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have hyperlinks (to URLs) embedded in a worksheet and want to be able to save the worksheet to PDF format and have the hyperlinks correctly translated as URL links in the PDF document, but in exploring various ways to save the worksheet to PDF I can't seem to find a way to may this work. I'm using Acrobat Pro 8.1.2 and Excel 12.1.2. Any guidance on whether or not this is possible using Acrobat or other 3rd party utilities would be appreciated.
 
F

fullnelson

Let me clarify a bit more... the hyperlink in the worksheet is showing a text name for a URL while the hyperlink itself is the actual URL. If I have the entire URL showing in a cell and save the Excel worksheet to PDF that way, the Acrobat PDF link to the URL works (and displays as the complete URL). However, if the entire URL is not displayed and printed (i.e., because the cell width is shortened or an adjacent cell prevents full display of the URL cell) then the PDF URL link does not work. My preferred solution is to have the text description of the embedded URL hyperlink become the PDF link to the correct URL without the actual URL text showing. Just wondering if this is possible.
 
P

Phillip Jones

Won't work

The Mac version office has never had the required code hooks need by
adobe to allow transferring of hot links directly from a Office document
to PDF.

Adobe has been harping on this for years, It comes up every few month on
the acrobat forum at adobe.

I don't know why its not done, for the Mac version but you've always
been able to on PC Version.

Let me clarify a bit more... the hyperlink in the worksheet is showing a text name for a URL while the hyperlink itself is the actual URL. If I have the entire URL showing in a cell and save the Excel worksheet to PDF that way, the Acrobat PDF link to the URL works (and displays as the complete URL). However, if the entire URL is not displayed and printed (i.e., because the cell width is shortened or an adjacent cell prevents full display of the URL cell) then the PDF URL link does not work. My preferred solution is to have the text description of the embedded URL hyperlink become the PDF link to the correct URL without the actual URL text showing. Just wondering if this is possible.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:p[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>
 
F

fullnelson

I tried Matt Broughton's suggestion of downloading, installing and using OpenOffice 3.0 beta and it works great! My PDF links are intact and fully operable. Thanks for the tip!
Now heads up to Microsoft before everyone defects to OpenOffice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top