How to Fix ‘Excel Hyperlink Not Working’ issue

213

Learn how to Fix ‘Excel Hyperlink Not Working’ issue in this guide. The incorporation of hyperlinks into your Excel sheet makes it easier to retrieve information that is related to it or to move to certain portions within a huge workbook. Through the use of hyperlinks, you are able to make your spreadsheet interactive and properly organize your data sources. On the other hand, what happens if these hyperlinks in Microsoft Excel stop functioning or responding? Excel hyperlinks that do not function properly are not an unusual occurrence.

Excel includes a function that allows you to create a connection between specific sites on the internet or on your own device. The use of this tool, nevertheless, does not always function as you anticipate it to. When anything like this occurs, you can anticipate seeing a dialog box that will notify you that a hyperlink is broken. Resolving the issue on your Windows 11 or 10 computer should not take a significant amount of time, regardless of whether it is a broken link or a problem with the Excel application. The following are some suggestions that should assist how to Fix ‘Excel Hyperlink Not Working’ issue.

Causes of the ‘Excel Hyperlink Not Working’ issue

1. File or Folder Changes: If the hyperlink points to a local file or folder, verify that there have been no changes in the file path or directory structure.
2. Security Settings: Evaluate whether security settings in Excel are blocking the hyperlink. Adjust settings if necessary.
3. Cell Formatting: Hyperlinks might not work correctly if the cell containing the link has specific formatting issues.
4. Hyperlink Type: Confirm that the hyperlink is created using the appropriate method (Insert Hyperlink) and not just as plain text.
5. External Program Interference: Check if third-party applications or add-ins are affecting Excel’s hyperlink functionality.
6. Software Updates: Ensure that Excel and the operating system are up-to-date, as updates may resolve known issues.
7. Document Corruption: If the Excel file is corrupt, it can affect hyperlinks. Try opening the file in a new workbook to see if the issue persists.

How to Fix ‘Excel Hyperlink Not Working’ issue

Verify the Hyperlink Address

1. Ensure the hyperlink address is accurate.
2. Right-click on the cell with the hyperlink.
3. Select ‘Edit Hyperlink.’
4. Verify the URL or cell reference.
5. Ensure there are no typos or missing characters.

Disable Protected View

1. Open Excel and go to ‘File.’
2. Select ‘Options‘ and navigate to the ‘Trust Center.’
3. Click on ‘Trust Center Settings.’
4. Disable ‘Enable Protected View for files originating from the internet‘ and ‘Enable Protected View for files located in potentially unsafe locations.’
5. Click ‘OK‘ to apply the changes.

Adjust Security Settings

1. Going to ‘File‘ and selecting ‘Options.’
2. Navigate to the ‘Trust Center’ and click on ‘Trust Center Settings.’
3. Choose ‘Macro Settings’ and select ‘Enable all macros.’
4. Click ‘OK‘ to save the changes.

Update Excel

1. Using the latest version of Microsoft Excel.
2. Updates often include bug fixes and improvements that may address hyperlink issues.
3. Check for updates through the ‘File‘ menu under ‘Account‘.
4. Then click on ‘Update Options.’

Repair Office Installation

1. Open ‘Control Panel’ and go to ‘Programs.’
2. Click on ‘Programs and Features.’
3. Locate Microsoft Office, right-click, and choose ‘Change.’
4. Select ‘Repair‘ and follow the on-screen instructions.

Check for Broken Links

1. If the hyperlink points to an external file, folder, or webpage, ensure that the linked resource is accessible.
2. Broken links can result from changes in file locations or deleted web pages.
3. Update the hyperlink to the correct address if needed.

Conclusion

An example of a valuable feature is a hyperlink. You can build a shortcut in Excel that will allow you to open a document that is saved on a network server or the Internet, or it will allow you to jump to another position within the current worksheet where you are working. Multiple customers, on the other hand, have claimed that they are unable to open hyperlinks in Excel.

Questions and Answers