Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»Excel Hyperlink Not Working? Here’s How to Fix It

Excel Hyperlink Not Working? Here’s How to Fix It

Asmi DhakalBy Asmi DhakalAugust 8, 2022
excel-hyperlink-not-working

It isn’t uncommon for hyperlinks in Excel to not work. Excel offers the feature of establishing a link between certain locations on either the web or your device. However, sometimes this tool does not work as you expect. When this happens, you can expect a dialog box alerting you about a broken hyperlink. 

If you’re facing a similar issue, we’re here to assist you. This article will break down the causes for why the hyperlink tool isn’t functioning in Excel. After that, we’ll give you insights on how you can fix this issue, so keep reading! 

Table of Contents

  • Why is Excel Hyperlink Not Working?
  • Fix the Hyperlink Issue in MS Excel
    • Enable Automatic Hyperlink
    • Update Path Name
    • Assign a Drive Letter (Windows)
    • Disable “Update Links on Save”
    • Repair Office App (Windows)

Why is Excel Hyperlink Not Working?

Excel lets you add hyperlinks that will redirect you to a relevant web page, document, or e-mail address. However, there isn’t a special hyperlink setting for MS Excel, so you may face a few problems with them. The problem can range from a rookie error to corrupted program files.

  • Automatic Hyperlink Disabled
  • Path Changed
  • Pound (#) Symbol Used
  • Disk Name Changed
  • Workbook Closed Unexpectedly
  • Corrupted Program Files

Fix the Hyperlink Issue in MS Excel

For each of the problems we’ve listed above, there are simple solutions you can try on your own. You don’t have to be an Excel expert to try these fixes because we’ve broken the fixes down into easy steps. After skimming through the problems, refer to the most relevant solutions listed below. 

Enable Automatic Hyperlink

You may have forgotten about turning off automatic hyperlinks in Excel. Microsoft pushed this feature so that you don’t accidentally create hyperlinks in your workbook. You can easily enable the automatic hyperlink feature for Excel through Proofing under Excel options. Although the steps may look long, we assure you it’s as easy as ever. 

Follow along with these steps to enable automatic hyperlinks for Excel:

  1. Launch MS Excel.
  2. From the homepage, locate and select Options from the sidebar. If you do not see Options, click on More, then select Options.
  3. From the Excel Options window, select Proofing on the left panel.
  4. Under AutoCorrect options, select the AutoCorrect Options… button.AutoHyperlink1
  5. Head on to the AutoFormat As You Type from the AutoCorrect window.
  6. Under Replace as you type, check the box next to Internet and network paths with hyperlinks.
    MS-Excel-AutoCorrect-Window
  7. Select OK on the bottom-right corner of the window to confirm changes.

After you’ve enabled this feature, select the cell with your hyperlink. From the formula bar, delete the space after the link and hit Enter on your keyboard.

Update Path Name

If your hyperlink is suddenly not working, the path must have been changed. MS Excel does not automatically update paths when changed, so you will be redirected to the path you’ve mentioned that no longer exists.

You can update the path name by editing the address leading to the file. While you check the path name, also ensure that the Pound symbol (#) is not mentioned in the address. If the address has the pound symbol, remove it. 

Here are the steps you can use to edit the address of your hyperlink:

  1. Open Microsoft Excel to open your document.
  2. Right-click on the cell with the hyperlink.
  3. From the list of options, select the Edit Hyperlink option.EditHyperlinkExcel1
  4. In the Edit Hyperlink window, locate Address. 
  5. Change the path name on the address bar next to Address. If any, remove the Pound symbol (#).
    MS-Excel-EditHyperlink-Window

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 stay static. As already mentioned, Excel does not identify path changes, so your hyperlink may not be working because the name of your disk is changed.

You can permanently assign a drive letter to removable memory from disk management. Remember, you need to have administrative access to complete this action.

Follow these steps to change the drive letter of a disk:

  1. Connect your removable disk to your computer.
  2. Launch Start, then type Disk Management and hit enter.
  3. Locate your driver under Volume and right-click on it.ChangeDiskLetter
  4. From the list of options, select Change Driver Letter and Paths…
  5. On the new window, click on the Change button.
  6. Next to Assign the following drive letter, select the drop-down menu and choose a letter you want to assign the disk.
    Windows-Disk-Management-Assign-Drive-Letter
  7. Select OK.

Disable “Update Links on Save”

Your hyperlinks may not work if your workbook is unexpectedly closed. This is because your workbook will fail to establish a connection with the location you wished to be redirected to. You can fix this issue by turning off the option, Update Links on Save from the Web options of Excel.

Here are the steps to turn off the Update Links on Save options for Excel:

  1. Open the Microsoft Excel application.
  2. From the panel to your left, select Options. If it is not available, click on More… then Options. If your document is already open, head to File from the menu bar.
  3. Select Advanced from the left panel.
  4. Scroll down to the General section.
  5. Click on the Web Options button.UpdateLinksOnSaveExcel
  6. From the Web Options window, navigate to the Files tab.
  7. Uncheck the box next to Update links on save under File names and location.
    MS-Excel-Web-Options-Window
  8. Select OK on the bottom-right corner of the window.

Repair Office App (Windows)

Some errors in Excel are caused due to corrupted or missing program files. When certain files do not work, you will not be able to enjoy the features the file contains. 

You can recover these missing or corrupted files by repairing the application. When you repair an app, your system scans for corrupted files and then swaps them for a new, working program file. 

Follow these steps to repair office application on Windows:

  1. On your keyboard, hit the combination Windows key + I to open the Settings application. 
  2. Select Apps from the navigation panel to your left.
  3. Click on Apps & Features.apps and features in windows settings
  4. Scroll down to locate the Office application.
  5. Click on the vertical Three-dot menu next to the application and select Advanced Options. 
  6. Scroll down to the Rest option, then select the Repair button.RepairApp
fix
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
Shared GPU Memory

What is Shared GPU Memory? How is It Different From Dedicated VRAM?

March 12, 2023
c drive vs d drive

C Drive Vs D Drive – What’s the Difference?

March 12, 2023
firmware vs software

Firmware Vs Software – What’s the Difference?

March 8, 2023
You may also like
Internet-Keeps-Dropping

Why Does My Internet Keep Dropping? 10 Ways to Fix It

March 16, 2023
hp-printer-light-flashing

Solved: HP Printer Light Flashing

March 16, 2023
scan disk windows 10

How to Scan Disk Windows

March 16, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.