Excel hyperlinks not working after convert to PDF

New Here ,
Oct 29, 2016 Oct 29, 2016

Copy link to clipboard

Copied

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.

TOPICS
Create PDFs, Edit and convert PDFs

Views

74.7K

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Community Professional , Oct 31, 2016 Oct 31, 2016
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 manua...

Likes

translate

Translate

Translate
Community Beginner ,
Apr 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

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.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 19, 2019 Nov 19, 2019

Copy link to clipboard

Copied

Uploading my excel workbook did NOT fix my broken links. Every solution presented here did not fix the broken links. I have one link working out of the 30 on my TOC page. They were all created manually using insert hyperklink, and they all work in the excel document. Definitely an ADOBE issue.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 23, 2019 Apr 23, 2019

Copy link to clipboard

Copied

I had this issue and it took forever to figure out a workaround but this worked for me:

  1. Export the Excel file as PDF/XPF document and save it without changing the features
  2. Print the PDF/XPF file as your PDF document

The links will work using this method.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 19, 2019 Nov 19, 2019

Copy link to clipboard

Copied

This did not work for me. I havd one working link and that broke after this process. Aslo, what if you only want some of the worksheets and not all.?

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 20, 2018 Jul 20, 2018

Copy link to clipboard

Copied

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

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jul 23, 2018 Jul 23, 2018

Copy link to clipboard

Copied

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.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 16, 2019 May 16, 2019

Copy link to clipboard

Copied

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

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 17, 2019 May 17, 2019

Copy link to clipboard

Copied

Same question here... external hyperlinks work fine, internal document navigation doesn't works.

Tried the work around with export to xps/pdf but didn't worked...

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 13, 2019 Aug 13, 2019

Copy link to clipboard

Copied

17A58DC.PNG

We found a solution / workaround here. UNchecking this box fixed the issue of no internal links working after an MS Office Update. Now our spreadsheets link again to the pages/tabs.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 13, 2019 Aug 13, 2019

Copy link to clipboard

Copied

Dear Leonard,

Could you please share your solution once more? It seems that I can't open the .PNG file.

Looking forward to your answer.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 14, 2019 Aug 14, 2019

Copy link to clipboard

Copied

In Acrobat PDFmaker settings,  uncheck the box under Application Settings, that says Enable Accessibility and Reflow with tagged Adobe PDF.

17A58DC.jpg

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 19, 2019 Nov 19, 2019

Copy link to clipboard

Copied

This did not work.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 12, 2019 Dec 12, 2019

Copy link to clipboard

Copied

Thank you Leonard, this worked for me!

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 27, 2020 Feb 27, 2020

Copy link to clipboard

Copied

FYI - I wanted to say that this solution also worked for me (unchecking the "Enable Accessibility and Reflow with tagged Adobe PDF" box in the Acrobat Preferences tab in excel). One thing that I did figure out additionally that I thought may prove helpful for some others: if you have used "Insert Links" to create your links in excel, and they are linking to a specific cell in excel, make sure the cell you are linking to falls within the Print Area of your Page Layout.

 

In my case, I found that my link wasn't working simply because it was linking to cell "A1" of another worksheet, but I did not have cell "A1" of that sheet in my print area. It was out of my own sheer curiosity that I tried expanding the print area, and voila! The link began working.

 

So long story short: make sure your in-workbook links are linking to cells that also fall within the print area that will be captured when converting to PDF.

 

Hope this helps!

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 17, 2020 Mar 17, 2020

Copy link to clipboard

Copied

Hi everyone,

All great ideas, but none worked for me - and i tried them all to date. My links (websites and documents) are brought in using the hyperlink function. All the actual URLs live on one tab and are brought in onto another sheet via formulas. I have various sheets with different parameters that lookup (index) the multiple lists of URLs. The links in excel work perfectly. However, to PDF, all links go away. Help please!

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Dec 05, 2018 Dec 05, 2018

Copy link to clipboard

Copied

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!

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 08, 2020 Feb 08, 2020

Copy link to clipboard

Copied

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?

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 05, 2020 Mar 05, 2020

Copy link to clipboard

Copied

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?

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 17, 2020 Mar 17, 2020

Copy link to clipboard

Copied

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. 

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 04, 2020 Aug 04, 2020

Copy link to clipboard

Copied

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. 

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 02, 2020 Nov 02, 2020

Copy link to clipboard

Copied

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. 

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 19, 2020 Nov 19, 2020

Copy link to clipboard

Copied

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...

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines