[Fixed!] Excel to PDF Hyperlinks Not Working (5 Easy Fixes)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, we need to add different kinds of files to our Excel worksheets for various purposes. In Excel, we can link the addresses of multiple PDF files to specific texts or specific cells. But in some particular cases, they may not work. There are some common issues with that. In this article, I’ll explain them and show 5 effective fixes if Excel to PDF hyperlinks are not working. Hence, read through it to learn more.


How to Fix When Excel to PDF Hyperlinks Are Not Working: 5 Easy Solutions

In Microsoft Excel, hyperlinks generate a shortcut that takes to a different part of the current workbook or a server or takes where the file is located. Actually, it assists in viewing information in various locations. This will make our work easier. In this part, I will show you 5 easy fixes for Excel to PDF hyperlinks not working. For the purpose of demonstration, I have used the following sample dataset.

Sample Dataset for Excel to PDF Not Working


1. Fix File Path

There are several reasons why a hyperlink may malfunction. Usually, it may occur due to an incorrect file path or URL, and the desired link will not open. For this reason, the file path or the URL needs to be corrected. However, you can not edit it in the PDF file; rather, you have to fix the file path in Excel and convert it into a PDF file again. Hence, follow the solution below.

📌 Solution:

  • First, select the hyperlink cell in the dataset.
  • Then, right-click and select the Edit Hyperlink option.

  • After that, fix the Address or URL and press OK.

Excel to PDF Hyperlinks Not Working by Fixing File Path

  • Finally, the file path is fixed. Now, you can save the file as PDF, and the hyperlink will work.

Read More: [Fixed!] Excel to PDF Size Problem While Printing


2. Add or Replace HTTP:// and HTTPS://

In general, HTTP stands for Hyper Text Transfer Protocol, and HTTPS means Hyper Text Transfer Protocol Secured. This part is quite significant when writing a hyperlink. Most of the time, the hyperlink may not work if this part is not provided in the initial part of the hyperlink. So, you have to add or replace HTTP:// and HTTPS:// in the hyperlink.

📌 Solution:

  • Initially, select the hyperlink cell in the dataset.
  • Next, right-click and choose the Edit Hyperlink option.

  • Then, write down the Address with HTTPS:// and press OK.

Excel to PDF Hyperlinks Not Working by Adding or Replacing HTTP:// and HTTPS://

  • Finally, export the file as PDF, and the hyperlink will work without any issues.

Read More: How to Deal with Margin Problem While Converting Excel to PDF


3. Create New Hyperlink

Furthermore, after creating a hyperlink by linking from another sheet or website, if you change the source sheet name or move the source file of the website, then your hyperlink won’t work. For such situations, you have to create a new hyperlink. Hence, you can read through the following solution in order to create a new hyperlink.

📌 Solution:

  • Firstly, select the hyperlink cell in the dataset.
  • Next, right-click and select the Edit Hyperlink option.

Excel to PDF Hyperlinks Not Working Creating New Hyperlink

  • Then, input the new hyperlink and press OK.

  • Lastly, save the file as PDF, and the hyperlink will now work properly.

Read More: How to Convert Excel to PDF without Converter


4. Disable Update Links Option on Saving

Unfortunately, there is a built-in option in Excel for which hyperlinks may not work properly. The option is called- Update Links on Save. Generally, this option updates the links whenever you save your files. If you enable this option, hyperlinks may not work in Excel. So, you have to uncheck it. However, go through the following solution.

📌 Solution:

  • In the beginning, click on the File tab.

  • Then, click on Options from the Dialog Box.

  • After that, click Advanced Web Options.

Disable Update Links Option on Saving for Excel to PDF Not Working

  • Now, open the Files section.
  • Then, unmark the Update links on save option and press OK.

  • At last, press OK again, and your hyperlink will work perfectly while saving as a PDF.

Read More: How to Convert Excel to PDF without Losing Formatting


5. Repair Corrupted Files for Excel to PDF Not Working

Sometimes, it also happens that your workbook may be corrupted. And if it gets corrupted, then you won’t be able to perform many tasks, including fixing hyperlink issues. However, the following solution may work.

📌 Solution:

  • First, recover your file if you have any backup.
  • Lastly, there are many repair tools available online; you can try them.

Read More: How to Convert Excel to PDF with All Columns


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


Conclusion

These are all the steps you can follow when Excel to PDF hyperlinks are not working. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan
Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo