Export Hyperlinks from Excel to PDF

Question

Dear support,

I've an excel file that contains several sheets. The first sheet is like a Table of contents for the remaining ones. It has got a specific header to each individual sheets.

I inserted a hyperlink in each header to navigate easily throughout the file. I have also home button in each sheet to return back to the first sheet (Table of Contents).

I want to save this file as a PDF file with all hyperlinks preserved, so I can also do the navigation easily in the PDF file.

I tried the following:

 1. file/save as PDF

 2. click on acrobat button and then select the sheets/convert to PDF

 3. Print/adobe PDF

I'm using:

 Adobe Acrobat Pro DC (32-bit)

 Microsoft office 2019

By the way, I was able to do the same job with word and PowerPoint. Though, I need it with excel.

I appreciate if you know how to solve this.

Thanks in advance.

Answer 1

Hi salehalawsh!

I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

Since you mentioned you have the Adobe Acrobat Pro installed, do you see the Acrobat tab in your ribbon? If so, then click on it, click on "Preferences" and make sure to uncheck the option "Enable Accessibility and Reflow with tagged Adobe PDF". Restart excel then try using Adobe's create PDF function in Excel and verify the result. Let me know if this works.

I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

Best Regards!

Jen :)

Answer 2

Hi Jen,

Thank you for your help. Unfortunately, it did not work.

Regards

Answer 3

Hi salehalawsh,

Just to confirm, did you use the Create PDF function in the Acrobat tab? Thanks in advance.

Answer 4

Yes I did

Answer 5

Hi salehalawsh,

Are you using the Hyperlink formula or you've created your links via a macro? Thanks in advance.