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.
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.
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.
- 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.
- Finally, the file path is fixed. Now, you can save the file as PDF, and the hyperlink will work.
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.
- 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.
- Finally, export the file as PDF, and the hyperlink will work without any issues.
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.
- Firstly, select the hyperlink cell in the dataset.
- Next, right-click and select the Edit Hyperlink option.
- Then, input the new hyperlink and press OK.
- Lastly, save the file as PDF, and the hyperlink will now work properly.
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.
- In the beginning, click on the File tab.
- Then, click on Options from the Dialog Box.
- After that, click Advanced ➤ Web Options.
- 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.
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.
- 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.
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.