Hyperlinks Not Working In Excel 2016

  

  1. Excel Spreadsheet Links Not Working
  2. Link In Excel Not Working
  3. Hyperlinks Not Working In Excel 2016 Free
  4. Hyperlink Not Working In Excel 2016
-->

Re: Hyperlinks not working. Go to Insert Hyperlink Put web address in Address Box. Please check the attache screen shot. If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. How do I activate hyperlinks in Excel? To use the Insert Hyperlink command, follow these steps to get started: Select the cell where you want the hyperlink. On the Excel Ribbon, click the Insert tab, and click the Hyperlink command. OR, right-click the cell, and click Link. OR, use the keyboard shortcut – Ctrl + K. Why do some hyperlinks not.

Hyperlinks in excel 2016 not working, giving below warning meassage when try to open Hyperlinks. Please help me to resolve the issue. Hyperlinks in excel 2016 not working after updated MS office patches on.

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

After a user inserts a hyperlink to a file residing on a network mapped drive within an Office product, the hyperlink's text displays the network mapped drive path, however the link is resolved as the UNC path.

For example, in Excel if you go to Insert, and then click on Hyperlink the user is prompted to select the file. If the user navigates to a file residing on a Network Mapped Drive, and inserts a hyperlink to that file, the hyperlink will be created to the file via its UNC path instead of its network mapped drive path. After the link has been inserted, the user can then hover over the link and see that the full UNC path has been used when creating the link to the file.

Cause

The cause is due to the way Office creates hyperlinks to files. Office products will create links to files using the UNC path and will not use the network mapped drive location, even if it displays it in the hyperlink text.

Resolution

There is no resolution for this. Microsoft recommends that users insert hyperlinks using the UNC path to prevent confusion in cases where opening a file via UNC or network mapped drive might make a difference in the expected behavior in the file.

More Information

An example of where how a file is opened can be found listed in this KB article under the section 'Scenarios that may cause links to not work as expected.'

328440 Description of link management and storage in Excel

Many users have reported an issue were they are unable to open hyperlinks sent through email. Upon further investigation, it has been found that the issue was specific to the MS Outlook app and not the mail server.

However, this case could be isolated. Try opening the email through the default browser on your system. If it works well there, then the issue is with the MS Outlook desktop application itself, else it is with the browser or the mail. In case it doesn’t work on the browser either, then try opening it on a different browser or a different system. Try checking other emails which have a hyperlink. Most probably, it should work, unless it is on some unreliable mail server.

The causes behind the issue could be many, so we would troubleshoot it sequentially isolating and removing every possibility of the problem:

Fix 1 – Edit Registry Key

1. Search CMD in Windows 10 Search Box and Right Click on it and Run as Administrator


2. Now, Run the following Command One By One in Command Prompt Window.

3. Now, Close Command Prompt Window and Open Outlook again.

Fix 2] Set the default browser to IE

Although no one likes setting the default browser to Internet Explorer, but some users have reported , that doing this fixes the issue. If you are really desperate to solve the issue, you can try this.

1] Search Default apps in Windows 10 search box

4] Now, in Web browser, click on your default browser and change it to Internet explorer.

3] In the default apps window, scroll to web browser and change it to IE.

Fix 3] Reinstall Chrome

Many users have reported that, uninstalling and re installing chrome browser fixes hyperlink not opening issue in windows 10. You can also try and check if it works for you.

Fix 4] Check issues with the mail server

While this issue has been isolated in the preliminary check, we could discuss it here. If the hyperlink is not working even when we have changed the browser and checked a different email, the issue might be with the email server. A few popular ones like Gmail, Hotmail, etc. are trusted, but many other local companies might offer services without the functionality to open hyperlinks. In this case, the issue cannot be resolved from our end.

After isolating this possibility, move to the following steps.

Fix 5] Use the Microsoft Office troubleshooting tool

Microsoft provides users with a tool to troubleshoot issues with Microsoft Office. The tool could be downloaded from here. After downloading the tool and installing it, check in the list for the concerned issue and run it. Restart the system once done.

Fix 6] Use the easy fix tool

Use the easy fix tool provided by Microsoft here in method 1. Run it and restart the system and check if it helps with the problem.

Fix 7] Repair Microsoft Office

If the issue is with the Microsoft Outlook desktop client, we would have to repair the whole Microsoft Office package.

1] Press Win + R to open the Run window. Type control panel and press Enter to open the Control Panel window.

Hyperlinks not working in excel 2016 pdf

2] Go to Programs and features. It would display the list of the installed programs.

3] Right-click on the Microsoft office package and and then select Change.

4] Select Repair >> Continue and then go through the repair process.

Restart the system once done.

Fix 8] Scrape off the Microsoft Office client and reinstall it

If a simple repair doesn’t work, scrape off Microsoft Office from the system and then install it again. Simply uninstalling it from Control Panel might not be sufficient.

1] Go to the link here and download the scrape tool provided in option number 2.

2] Run the tool and it will delete all components of Microsoft Office from the system.

3] Re-install Microsoft Office from either the disk or online. The same key could be used again if still valid.

Hope it helps!

Related Posts: