Skip to main content
New Participant
October 29, 2016
Answered

Excel hyperlinks not working after convert to PDF

  • October 29, 2016
  • 11 replies
  • 147119 views

I am using your Acrobat Pro XII trial version, I am running Excel 2016 for PC.  I have hyperlinks in my excel form and when I convert it to PDF they do not transfer over.  I have tried "Save as" a PDF and also "Print", save as PDF, convert the Excel file to PDF using Adobe PDF maker. none will work. 

Please help.

This topic has been closed for replies.
Correct answer Karl Heinz Kremer

Sure, thank you.

[Removed the link as the file contains contacts information]


The problem is that you've created your links via a macro - for the link to work, Excel needs to execute the HYPERLINK macro, and get it's target from a different cell. No macros in an Excel document are getting converted to JavaScript in the PDF file. If you create your links as true links (Insert>Hyperlink), then the link will survive the conversion to PDF. You have two options: You can either convert your links in the Excel documents to true (and static) links, or you can add your links manually in Acrobat using the link tool.

11 replies

New Participant
July 8, 2021

I have tried every way possilbe using Excel and can't get it to work. What I did do what import my spreadheet into google docs, and then "download" the spreadsheet as a PDF. That maintained the hyperlinks.

New Participant
July 8, 2021

Correction: into Google SHEETS

New Participant
May 26, 2021

I read through the list of 'solutions' and none of them worked for me. What I ended up having to do is save the file as an html page and then print the html page to PDF. This ended up converting the hyperlinks to PDF. I know it's a little bit of a hack, but it worked for me. Hopefully this is helpful to someone else.

New Participant
November 20, 2020

So I've been having a similar issues.... this may apply to you as well... I thought I had an issue, until I realized that it is hyperlinking to PDF **BUT** because I merged a bunch of cells to fit the hyperlink, it only recognized the first cell in the merge. Basically, simple solution was to unmerge the hyper link text, then insert the link across several cells, instead of just one cell. The text will still show up across all the cells, as long as there is no text in the cells adjacent to it. I hope this helps...

New Participant
August 4, 2020

I had a similar problem. I wanted to make a Phone Directory for work which was loaded up to Microsoft TEAMS. I searched everywhere. I was stuck with uploading an Excel file. It worked but I wasn't happy with it.

Then through a lot of trial and error I found in Excel I go to "Page Layout" and select "Print Area". I then save the document and select Copy. The go to Word and Paste it. From there I can adjust the Custom page size to fit and I even changed the Paper colour to match the Original Excel file so I don't see the white areas at the bottom. It now looks and operates just like an APP, so good. Now to use the Phone directory the other staff only need to click on the name and the dialer opens up on their phone and they're on their way! I'm now making a contact list for all the other departments. 

So to summerise, Excel- copy your work- paste to word, then save as a PDF. 

New Participant
November 2, 2020

Links exported from Excel to a PDF are suboptimal in Adobe Acrobat DC if the link is in a merged cell. Merged cell links may not work or only work in one area and not others where the text is or is not. Be sure your link is in a unique cell for best results. Using PC, Excel 2016. 

New Participant
March 17, 2020

Hi Karl,

it has been 4 years since this issue first arose. It continues to be a problem. People using the hyperlink function and then converting excel sheets to pdf lose their hyperlinks. is there a solution being worked on, or an efficient work-around?

I have over 100 sheets with one tab as the source to a huge list of URLs that the sheets populate from in accordance to specific parameters. Once converted to pdf, not one single link on the sheets stick. 

There has to be a better way than to manually add them all back in Acrobat using the link tool. 

New Participant
March 5, 2020

I created my hyperlinks using =Hyperlink(,). I did this because I want the hyperlink to have text that can be pulled from a column and link that can be pulled from another column. This will allow the updating of the names and links from a master sheet routinely without need to go into all of the sheets that pull the same data. I can't get (Insert > Hyperlink) to pull the data from my existing columns. Am I missing something? Is there a way to use (Insert>Hyperlink) to pull from existing columns?

Participating Frequently
December 5, 2018

If you are lucky enough to be using Excel on a Mac not a PC, then the chances are you have the (free) spreadsheet program Numbers too, if not download from the App Store.

Apple know that you probably want links to work when you export a PDF, Numbers can also open Excel files, so steps are as follows:

  1. open your Excel file in Numbers
  2. export as a PDF, the links just work.
  3. there is no 3, its that easy.

Sorry, I know that is of no help to Windows users, I'm unfortunate enough to have to use Windows for most of my work, but if you've got a Mac, its easy this way!

New Participant
February 8, 2020

Hi.  Im hoping someone can assist. I am trying to create a hyperlink in an excel document.  When creating the link by inserting a hyperlink, I do not have the option of choosing any PDF documents for some reason.  I can view all other file types but the PDF documents dont even show in the folder.  Any advice?

New Participant
July 20, 2018

Hi, have the same problem like reported yet by several peoples here.
Adobe is very bold: NO solution! Issue caused by ADOBE is shown: working on old Version of Acrobat DC pro 2015.016.20045 - NOT working on current Version 2018.011.2005. In both cases identical versions of Excel and identical input xls-file have been used.

Adobde SUPPORT chat was CANCLED without offering any solution by Adobe!
Citation in German:
"Christoph:

Es liegt nicht in meiner Absicht Sie zu verärgern. Ich kann Ihnen hierbei allerdings keine Lösung anbieten, da die Quelle der PDF Excel ist. Excel gehört zu Microsoft und kann daher auch nur von Microsoft supportet werden. Da wir uns hier leider im Kreis drehen, werde ich den Chat jetzt beenden. Ich bitte um Ihr Verständnis und wünsche Ihnen noch einen angenehmen Tag.

Die Verbindung wurde vom Mitarbeiter beendet. "

STRANGE and outrageous reaction by ADOBE

AnandSri
Community Manager
Community Manager
July 23, 2018

Hello Wolfgangw,

I am incredibly sorry for the inconvenience you had and the experience with the chat support. The issue is already reported to the development team and they are working on a solution/workaround, however, the delay is due to the dependency we have on Microsoft.

Would you mind sharing few details so that we can assist you in a better manner:

Thanks for your time and patience thus far.

Thanks,

Anand Sri.

New Participant
May 16, 2019

Hello Anand,

is there a official process are working instruction how to tackle this problem? I have a large document with about 80 tabs which are linked to an index with hyperlinks. Once I export this to Adobe Pro 8 it doesn't work.

I could share a test document with only one tab which is edited in MS Excel 365.

Would you be able to assist me on that?

Regards

Inspiring
April 23, 2018

FYI - Per one of my company's IT contract people, this is a known issue with Excel 2016/365 and is most likely Microsoft's problem to fix. (He tested for this problem on other PDF maker software and found the same problem.)

Unfortunately, I was also told that Microsoft is NOT ACCEPTING BUG REPORTS for Excel 2016/365 at this time, so we are stuck trying to work around it.

For me, this results in me still using Excel 2007 when I need hyperlinks, which to be honest SUCKS...but it's not Adobe's issue.

If anyone has further information it would be great to hear it here at some point.

Inspiring
April 24, 2018

Thanks for the reply and the workaround. That helps !

Inspiring
April 24, 2018

Just had a reaction from Adobe

Could you try converting excel to pdf using a web browser at this link: https://cloud.acrobat.com/convertpdf and check if internal links work fine.

That works! So it seems that it is not an Excel problem.

Karl Heinz  Kremer
Brainiac
October 30, 2016

Both options you've used ("Print to PDF" and "Save as PDF") will not bring over the links to the PDF document. When you look at the combination of Acrobat and MS Word, you have at least three different ways to convert to PDF: Word comes with it's own PDF generator that is available even when Acrobat is not installed. Once you install Acrobat, you have two more methods: You can print to the "Adobe PDF" printer, and you can use the "PDF Maker" macro that installs a toolbar or a ribbon in your MS Office application. Printing to PDF will always strip out any interactive content (and more), only the PDF Maker will give you a high quality PDF file. Follow Tariq's instructions to verify that the setting is correctly selected, and then use the "Create PDF" on the Acrobat toolbar to actually generate the PDF output file.