It is not uncommon for hyperlinks in Excel not to work. Excel offers the ability to link certain locations on the web or on your device. However, sometimes this tool does not work as expected. When this happens, you can expect a dialog to warn you of a broken hyperlink.
If you’re having a similar issue, we’re here to help. This article will break down the causes why Hyperlink tool not working in Excel. After that, we will tell you how to fix this problem, so keep reading!
Why is Excel hyperlink not working?
Excel allows you to add hyperlinks that will redirect you to a relevant web page, document or email address. However, there is no special hyperlink setting for MS Excel, so you may encounter some issues with them. The problem can range from a rookie mistake to corrupt program files.
- Automatic hyperlink disabled
- Changed path
- Pound symbol (#) used
- Disk name changed
- Workbook closed unexpectedly
- Corrupt program files
Fix Hyperlink Problem in MS Excel
For each of the problems we’ve listed above, there are simple solutions you can try for yourself. You don’t need to be an Excel expert to try these fixes because we’ve broken them down into simple steps. After going through the issues, refer to the most relevant solutions listed below.
Enable Auto Hyperlink
You may have forgotten to turn off automatic hyperlinks in Excel. Microsoft pushed this feature so you don’t accidentally create hyperlinks in your workbook. You can easily enable auto hyperlink feature for Excel via Proofing under Excel Options. Although the steps may seem long, we assure you that it is as easy as ever.
Follow these steps to enable automatic hyperlinks for Excel:
- Launch MS Excel.
- From the homepage, locate and select Choice from the sidebar. If you don’t see Choiceclick on After, then select Choice.
- In the Excel Options window, select Proofing on the left panel.
- Under AutoCorrect options, select the Autocorrect options… button.
- Head to the Auto-formatting as you type from the autocorrect window.
- Under Replace as you type, check the box next to Internet and network paths with hyperlinks.
- Select OKAY in the lower right corner of the window to confirm the changes.
After enabling this feature, select the cell with your hyperlink. In the formula bar, remove the space after the link and press Walk in on your keyboard.
Update path name
If your hyperlink suddenly isn’t working, the path must have been changed. MS Excel does not automatically update paths when they change, so you will be redirected to the path you mentioned which no longer exists.
You can update the path name by modifying the address leading to the file. While you are checking the path name, also make sure that the Pound symbol (#) is not mentioned in the address. If the address has the pound symbol, remove it.
Here are the steps to change your hyperlink address:
- Open Microsoft Excel to open your document.
- Right click on the cell with the hyperlink.
- From the list of options, select the Edit Hyperlink option.
- In the Edit Hyperlink window, find Address.
- Edit the path name in the address bar next to Address. If applicable, remove the Book symbol (#).
Assign a drive letter (Windows)
The alphabet assigned to external drives is temporary. However, if your hyperlink redirects you to an external device, its name must remain static. As already mentioned, Excel does not recognize path changes, so your hyperlink may not work because your disk name is changed.
You can permanently assign a drive letter to removable memory from Disk Management. Remember that you must have administrator access to perform this action.
Follow these steps to change the drive letter of a disk:
- Connect your removable disk to your computer.
- Launch Beginthen type disk management and press enter.
- Locate your driver under Volume and right click on it.
- From the list of options, select Change driver letter and paths…
- In the new window, click the To change button.
- Close to Assign the following drive letterselect the drop-down menu and choose a letter you want to assign to the drive.
- Select OKAY.
Disable “Update links on save”
Your hyperlinks may not work if your workbook is closed unexpectedly. This is because your workbook will fail to establish a connection to the location you want to be redirected to. You can solve this problem by disabling the option, Update links on save from Excel’s web options.
Here are the steps to disable link update options on record for Excel:
- Open the Microsoft Excel application.
- In the panel to your left, select Choice. If not available, click After… then Choice. If your document is already open, go to Case from the menu bar.
- Select Advanced of the left panel.
- Scroll to General section.
- Click on the Web Options button.
- In the Web Options window, navigate to Files tongue.
- Uncheck the box next to Update links on save under File Names and Locations.
- Select OKAY in the lower right corner of the window.
Repair Office application (Windows)
Some errors in Excel are caused by corrupt or missing program files. When certain files are not working, you will not be able to enjoy the features contained in the file.
You can recover these missing or corrupted files by repairing the application. When you repair an application, your system searches for corrupt files and then replaces them with a new, working program file.
Follow these steps to repair the Office application on Windows:
- On your keyboard, press the combination windows key + I to open the Settings application.
- Select apps in the navigation panel to your left.
- Click on Apps and Features.
- Scroll down to locate the Desk application.
- Click on the vertical Three-dot menu next to the application and select Advanced options.
- Scroll down to the Rest option and then select the Repair button.