The hyperlink is a very useful feature to follow through any data or resource by simply clicking or tapping. Like many other Office software, Microsoft Excel allows us to create, insert and edit hyperlinks in our contents. But sometimes the hyperlinks get invalid. This may be caused by various reasons by various parties. This article will focus on how to fix these broken hyperlinks in Microsoft Excel.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
Possible Reasons That Cause Hyperlinks to Be Broken in Excel
Generally, clicking on a hyperlink should take you to another cell, workbook, or website. But if that isn’t happening then the hyperlinks can be called “broken”, as it isn’t working as intended anymore. This can happen for various reasons. Here are some possible reasons that a link inside your workbook is not working anymore.
Change in the Name of the Hyperlinked File
If a hyperlink is connected to a file, the file name is an integral part of the link. The system connects the files through this link. Now if you change the file name for some reason later, the link will search for it through the same name you saved before and so won’t get any results. And thus the hyperlink will get broken.
“#” in the Linked File Name
Hyperlinks do not accept pound signs (#) while creating a hyperlink. If your file has the sign within its name, the sign gets inserted into the link and the hyperlink gets invalid.
Sudden System Shutdowns
Abrupt closing of Excel without saving causes some features to not function properly. Hyperlinks fall in this category. Especially if the system shuts down suddenly and improperly while working with hyperlinks in Excel, it may not be saved properly and hence the links get broken. To fix this issue, you need to change the save settings for links.
Change of Linked File’s Path
The hyperlinks comprise of the linked file’s path and the file name. We have talked about the link getting broken because of the file name change. The same thing is applied to the file location. If someone changes the file location for some reason after creating the hyperlink, the link still searches for the file by the previously saved location. Which in turn results in vain. So the hyperlink gets broken.
Corrupt Program Files
Sometimes the files, both Office files, and the linked files get corrupted. This causes the links to not function properly sometimes.
5 Efrective Ways to Fix Broken Hyperlinks in Excel
We are going to go over five possible ways to fix broken hyperlinks in Excel. Different methods can work at different times depending on the cause that makes the hyperlinks invalid. So make sure to check each of them out.
For the demonstration, we are using the following dataset comprising hyperlinks.
If we click on the content of cell C5, the following error message appears indicating a broken hyperlink.
In such cases, you may try one of these possible fixes that can help you out with the issue.
1. Editing Broken Hyperlinks
If any change in the file’s name or destination is breaking the hyperlinks then this method is the best way to fix the broken hyperlinks in Excel. Follow these steps to see how we can do that.
- First of all, right-click on the cell containing the broken hyperlink.
- Then select Edit Hyperlink from the context menu.
- After that, click on the Browse icon in the Edit Hyperlink box.
- Then select the proper file again through the file explorer box.
This will fix the broken hyperlinks in Excel if the file path or name change was causing the issue.
Read More: Why Do My Excel Links Keep Breaking? (3 Reasons with Solutions)
2. Renaming and Removing ‘#’ Sign from File Name
As mentioned in the causes, if the file name contains the pound sign (#) the hyperlink gets invalid. This is because hyperlinks don’t support any # sign within them.
Take a look at the following file name.
It contains a pound sign within it.
If we link the file in our spreadsheet, we will see the same error message again.
To avoid this, rename the file to this.
Now edit the hyperlink again as shown in the previous method and click on the link again. It should fix the broken hyperlinks in the Excel spreadsheet.
3. Modifying Excel Options to Save Hyperlinks
Use this method to allow hyperlinks to get saved. This will fix broken hyperlink errors in cases the saves aren’t proper. This is more of a precaution than a solution. But try to use this one beforehand if you are working with hyperlinks.
- First of all, click on the Files tab on your ribbon.
- Then select Options from the left side of the backstage view.
- Now select Advanced from the left side of the Excel Options box.
- Then scroll down and select Web Options under the General section.
- After that, click on OK.
- Next, select the Files tab in the Web Options box.
- Then uncheck Update links on save option under the File names and locations section.
- Finally, click on OK on both boxes.
This will fix future broken hyperlinks issues in Excel that can happen because of sudden shutdowns.
Read More: How to Find Broken Links in Excel (4 Quick Methods)
4. Disabling Broken Hyperlinks
Another one you can follow is to remove the hyperlinks completely. If you don’t need the hyperlinks anymore and it isn’t working either, you can just remove them and make the file lighter in size and junk free. Follow these steps to remove or disable a hyperlink.
- First, right-click on the cell with the broken hyperlink.
- Then select Edit Hyperlink from the context menu.
- After that, select Remove Link in the Edit Hyperlink box.
- Finally, click on OK.
This will completely remove the broken hyperlink from the cell.
5. Repair Microsoft Office
If your problem still persists after trying all of these solutions, then try repairing the Microsoft Office to see if that makes any difference. Follow these steps to repair Microsoft Office in windows.
- First of all, go to Settings by clicking on the windows icon on the bottom-left of your screen.
- Then select Apps.
- After that, select Apps & Features from the left side of the window.
- Now scroll down on the left and find Microsoft 365 or the one you are using.
- Then select Modify under it.
- Now select Quick Repair or Online Repair depending on the one you prefer.
- Finally, click on Repair.
This may sometimes fix broken hyperlinks and make them workable again in Microsoft Office programs like Excel.
These were all the methods you can follow to fix broken hyperlinks in Excel. Hopefully, you can edit and fix your hyperlinks with ease now. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below.
For more guides like this, visit ExcelDemy.com.