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

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

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

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

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 ,
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]

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

Copy link to clipboard

Copied

Can you please also share your PDF file. Thanks.

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

Copy link to clipboard

Copied

Sure, thank you.

[Removed the link as the file contains contacts information]

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 Community Professional ,
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.

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 ,
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!

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

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
Most Valuable Participant ,
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?

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

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

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

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

Copy link to clipboard

Copied

I am having the same issue....any solutions that 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
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.......

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

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

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

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

Copy link to clipboard

Copied

Open the Excel in OpenOffice and export as 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 ,
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

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

Copy link to clipboard

Copied

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

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

Copy link to clipboard

Copied

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.

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

Copy link to clipboard

Copied

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.

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

Copy link to clipboard

Copied

Thanks for the reply and the workaround. That 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