• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

127.3K

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

Community Expert , 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

...

Votes

Translate

Translate
Adobe Employee ,
Oct 30, 2016 Oct 30, 2016

Copy link to clipboard

Copied

Hi Cowinkidink1, 

Once you open the excel sheet, click on Acrobat tab, click on preferences, check Settings tab and check if "Add links" is checked.

If yes, hyperlinks should work in PDF.

How did you convert the file to pdf? Is it possible to share that excel sheet with us?

Regards,
Tariq Dar.

Votes

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 ,
Oct 30, 2016 Oct 30, 2016

Copy link to clipboard

Copied

Hello Tarig,

Thank you kindly for replying to my inquiry.

I checked the Add Links and it is checked. Tried again and the hyperlinks are appearing in the converted file , however, I can not click on the link. May I send you the Excel file and you take a look? How would I send the file?

Kindest regards.

Votes

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 ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Hi Cowinkidink1,

Yes, you can upload the file to either of these cloud options Google drive, dropbox or Adobe Send.

Then using private message to share the file with us. How Do I Send Private Message

Regards,

Tariq Dar.

Votes

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 ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Hello Tarig,

I shared the link to the file here. I hope that is okay.

Again, thank you for your guidance.

[Removed the link as the file contains contacts information]

Votes

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 Expert ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Can you please also share your PDF file. Thanks.

Votes

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 ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Sure, thank you.

[Removed the link as the file contains contacts information]

Votes

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 Expert ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

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.

Votes

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 ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Thank you Karl and Tariq.

I very much appreciate the guidance and advice. I will try your suggestion when I return from an appointment later today.

Have a nice day!

Votes

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 24, 2017 Jul 24, 2017

Copy link to clipboard

Copied

Hi Karl,

I am having the same problem with my excel file not converting the hyperlinks when creating a PDF using the Adobe PDF Maker. I have verified the links are created in excel (Insert>Hyperlink) and the add links feature is checked. The hyperlinks in excel work and take me to diferent cells in the workbook, however, once I convert to PDF the hyperlinks appear but do not work.

Thanks,

Heather

Votes

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 Expert ,
Jul 24, 2017 Jul 24, 2017

Copy link to clipboard

Copied

When you convert an Excel file to a PDF there are no more cells, so how could it work?

Votes

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 24, 2017 Jul 24, 2017

Copy link to clipboard

Copied

I'm not sure. I have used the feature before and it has worked, however, on my new workbook it does not work. In adobe, it takes you to the page the cell is located on.

Votes

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 ,
Dec 26, 2017 Dec 26, 2017

Copy link to clipboard

Copied

I am having the same problem as Heather.

I have a workbook created to be a PDF report when complete, with hyperlinks to various points inside the file itself. (From the Table of Contents to other pages, and from the page titles back to the ToC, etc.) These worked fine in Excel 2007 when I used "Create PDF", but now that I'm remaking this file in Excel 2016, the hyperlinks do not come across in the PDF creation process.

I have confirmed that "Add Links" is checked in Preferences.

I have tried creating the hyperlinks three different ways:

- Via the HYPERLINK formula (I know this does not work, tested it just for confirmation)

- Via Insert Link / Place in this Document / "Sheetname!A1"

- Via Insert Link / Place in this Document / Named Location

None of these hyperlinks work when the file is PDFed! Please help! These worked fine for the last year, I don't see why Excel 2016 would lose this functionality!

2018 Hyperlink Help - Google Drive

Here are three files to refer to: The SAMPLE ANNUAL is last year's file. Notice that from the Table of Contents, you should be able to click on the page names to jump to those locations in the report.

The Hyperlink Testing.xlsx is the Excel file, and the PDF created from it with the same name.

Votes

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
Enthusiast ,
Jan 13, 2018 Jan 13, 2018

Copy link to clipboard

Copied

I am having the same issue. I downgraded from Acrobat DC to Acrobat XI and now have the issue that links are not included in my PDF. Have tried all of the above, used the toolbar, made the setting, went through all compliance: I got it to work for regular text hyperlinks, but if I attach hyperlinks to an image in excel, NADA. It worked before with DC.

There is no way I am EVER upgrading to DC again, so please no comments to that regard. If anyone has an idea over and beyond the already mentioned, please let me know!

Its amazing how many post I have open at Adobe with no solutions. My Illustrator still crashes since two years, no help there either. I can only say that I have the feeling the apps are getting worse not better. Unfortunately, there is no real competition and Adobe's monopoly and government involvement is not helping produce stable apps.

Its frustrating...

Cheers.

Votes

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 19, 2018 Apr 19, 2018

Copy link to clipboard

Copied

I am having the same issue....any solutions that work?

Votes

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 ,
Apr 23, 2018 Apr 23, 2018

Copy link to clipboard

Copied

I am having the same problem. It seems Adobe does not care.......

Votes

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 ,
Jun 10, 2022 Jun 10, 2022

Copy link to clipboard

Copied

Hello,
I have been searching for solutions to make a dynamic hyperlink survive the conversion to PDF and i couldn't find any.
It is clear in your comment that only static links will be exported.
Is this still the same after 6 years? or do you think there is a solution? or a turnaround maybe??
I did many trials, like "index and match", "if", reference to another cell, with IF in that cell, ... all works perfectly in excel, but none survived the export.

Votes

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 ,
Jun 11, 2022 Jun 11, 2022

Copy link to clipboard

Copied

As well, since i don't have many options for linking, i have tried to use multiple static links, and use conditional formatting for the links i don't want to show, by changing the color of the text, or hiding the text with three semi columns in format ";;;", but the link will still be there in both options (even if the text don't show, the blank cell is clickable)

Votes

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 ,
Oct 27, 2022 Oct 27, 2022

Copy link to clipboard

Copied

LATEST

I actually got it fixed if you or anybody still looking for a solution. 

FYI, I was creating a link to an existing document on the server drive to which employees in the company has access, so they can use my pdf and easily open in it the documents I linked. (It was not the web page linked)

So, my steps: 
1. Right click on the cell with text >> Link >> Insert link (To get that insert link window open).

2. Righ click the document I need to link >> Properties >> Copy the location of the file (i.e. Z:\2021\Current Project\RFI's\RFI 001 - First)
3. Insert this location path to the excel link window and add the file name in the end. It should look something like Z:\2021\Current Project\RFI's\RFI 001 - First\FileName.pdf

4. Export excel sheet to pdf and you should be good to go. Links are opening the pdfs I linked (not in acrobat, in browser instead, but I am okay with that).

Votes

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
Engaged ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

The Excel file is gone, so I'm not sure of the appearance of your links. If the display text is the URL in the PDF, you may be able to "convert URLs to hyperlinks" in Acrobat. This creates real hyperlinks from URLs in Acrobat and is found in the Document Processing panel.

Votes

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 Expert ,
Oct 31, 2016 Oct 31, 2016

Copy link to clipboard

Copied

Take a look here for instructions about how to use Adobe's own Document Cloud to share a file: Share Documents via Adobe's Document Cloud - KHKonsulting LLC

Votes

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 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

Hello, I am exporting a file from Excel to PDF. The file consists of a table of contents and several worksheets.  The table of contents is hyperlinked to all the separate sheets in the document while on Excel format.

When exporting to PDF however I lose the hyperlinks. Do you have any suggestions on how to solve this problem?

I have bought Adobe Pro and have activated the “Add links” check box under the ACROBAT – preferences tab.

Votes

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 Expert ,
Apr 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

Open the Excel in OpenOffice and export as PDF.

Votes

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 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

sorry, I forgot to include that it must be done through a Macro.

new message:

Hello, I am exporting a file from Excel to PDF through a Macro. The file consists of a table of contents and several worksheets.  The table of contents is hyperlinked to all the separate sheets in the document while on Excel format.

When exporting to PDF however I lose the hyperlinks. Do you have any suggestions on how to solve this problem?

I have bought Adobe Pro and have activated the “Add links” check box under the ACROBAT – preferences tab.

here is my export PDF macro:

Sub PRINTPDF_()

'

' PRINT_ Macro

ActiveWorkbook.Sheets.Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _

    "Monthly Progress Report.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, _

     IgnorePrintAreas:=False, OpenAfterPublish:=True

    'Application.PrintCommunication = True

    'ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _

        'IgnorePrintAreas:=False

End Sub

Votes

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 Expert ,
Apr 24, 2018 Apr 24, 2018

Copy link to clipboard

Copied

When you print to Adobe PDF you will not get working links.

Votes

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