Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel workbook with an index page containing a series of images, that are each hyperlinked to different worksheets. Can anybody suggest how I can publish this to PDF so that the hyperlinks work in the PDF? When I publish or use PDF Factory, the hyperlinks are not preserved (and bookmarks aren't created for that matter either).

I would prefer to do this with inbuilt functionality or free tools, though any suggestions welcome.

Also, it doesn't necessarily have to be with Excel. Publishing from powerpoint would be almost as good, and failing that, any easy solution which allows me to create a PDF containing clickable images that takes one to internal bookmarks might also be a workaround.

share|improve this question
    
You really need to either learn the PDF markup or buy Acrobat for that, sorry. –  digitxp Feb 1 '11 at 22:31
    
I've worked out that saving as PDF from Word will do this...i.e. internal hyperlinks are migrated to the PDF. However Excel and Powerpoint don't seem to do it. On the other side, you can edit the resulting PDF with Acrobat or 3rd party tool like Foxit Phantom to insert the links afterwards. –  Nicholas Feb 3 '11 at 21:19

8 Answers 8

PDF hyperlinks need to be defined/created with the PDF authoring tool. Excel doesn't know anything about PDFs, so its hyperlinks don't necessarily mean anything in PDF format unless your authoring tool can both read the Excel links and translate them into the PDF it authors. It sounds like pdfFactory doesn't do this on its own. Perhaps pdfFactory Pro would grant you the feature set necessary to achieve this.

Adobe Acrobat is the application that works with the PDF format most natively, and can definitely do this, but it is pricey. There may be alternative 3rd party software that can also do links; you may be able to take your PDF without links and use some software like that to add them later.

This list of PDF software may be helpful.

share|improve this answer

Only hyperlinks in Excel(2007) that link to external url work in the conversion to PDF even with Adobe Writer. Internal document reference link do not translate in PDF because the reference is lost in the save as.

share|improve this answer

I found that if I save the document as a web page, and then open it via Adobe Acrobat pro, it maintains the hyperlinks (downside is that it stuffs up the formatting).

share|improve this answer

Just use Adobe PDF, it works perfectly in there. But make sure the links are linked to defined names, not cells.

share|improve this answer

PDF Factory pro just acts like a printer. it takes a 'picture' of your document, and makes it into a PDF.

You will need to use software that actually creates a PDF without a printer driver, such as PDF Studio, Bluebeam, Nitro, Adobe, or several other tools.

share|improve this answer
up vote 0 down vote accepted

I've worked out that saving as PDF from Word will do this...i.e. internal hyperlinks are migrated to the PDF. However Excel and Powerpoint don't seem to do it.

According to the answer I'll upvote, Excel will export external hyperlinks, not internal.

share|improve this answer

I use hyperlinks in Excel 2007 to give a quick way for people to click & view pdf documents from the excel spreadsheet.

Basically I did the following:

  1. Save your PDFs in a folder on your computer/network.
  2. Then add a column in your spreadsheet to put the saved folder location.
  3. Also have the pdf file names in a column as well.
  4. In another blank column, enter a 'hyperlink' function from the Fx toolbar. ="PDF File Folder" (you might need to add an additional / at the end if it is not there) &"PDF Name"

  5. You can also name the hyperlinks whatever you want them to show as, I just list mine as 'Certficate Hyperlink' but that's just my preference.

  6. Click the hyperlink, and it should bring up the PDF listed for that row.

I can send a snap shot example if needed. Good luck, it's a lot easier than expected.

share|improve this answer

I was not able to get external hyperlinks to export as pdf either by printing to pdf or by save as pdf while using Excel 2007. I was, however able to get the external links to publish to pdf by going to "save as" and then to "other formats" and then selecting .pdf. As for internal links still not working.

share|improve this answer
1  
Please note that the question specifically addresses an issue with internal links. Your answer, while helpful, will not resolve that issue. Thus, it is very likely to be removed from Super User. –  Oliver Salzburg Jul 27 '12 at 21:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.