PDFs created from Excel, some links don't work

You can ask general questions, share opinions or advices about doPDF.
scooterInPa
Posts: 1
Joined: Fri Mar 06, 2015 10:26 pm

PDFs created from Excel, some links don't work

Postby scooterInPa » Fri Mar 06, 2015 10:35 pm

In Excel, if I create a link in Excel by simply typing the link, the link will work when I print the spreadsheet as a PDF.
Example: http://www.google.com/

If I create the link using the Excel function =HYPERLINK(), it doesn't work in the printed PDF. The text is blue and underlined, but the link doesn't work.
Example: =HYPERLINK("https://www.google.com/foo?bar=" & H21, H21)

Is this by design? Is there any chance you can make this work?

Thanks,
Scooter

Softland
Posts: 1443
Joined: Thu May 23, 2013 7:19 am

Re: PDFs created from Excel, some links don't work

Postby Softland » Thu May 14, 2015 7:51 am

Hi,
The link must be visible such as http://www.novapdf.com/ to be converted via the regular printer driver.

However, you can use the add-in for Excel that comes with doPDF to print and that will recognize "hidden" hyperlinks such as the one you gave as an example.


Return to “General”