Forum Discussion
Hyperlinks Not Resolving to Credentialed Website
I have an Excel file where I have built hyperlinks based on formula so that when reviewing applications I can click on the link and take me directly to view the application URL. I take the URL from the website and add a variable of the application ID number which then creates a direct link to the application itself. The application is on a credentialed website that requires a login. If I paste the link from Excel directly into my browser where I am already logged in the link resolves correctly and takes me to the application. However when I click on the same link from Excel I am taken to a login screen that simply says "you are logged in". No other error messages.
I found this help article(https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/cannot-locate-server-when-click-hyperlink) which seems to match my problem closely, however when I follow the instructions I cannot find the required registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet). When I get to \Office I have 14.0, 15.0 and 16.0 but none of them have \Common\Internet in them.
Things I've tried to resolve:
- Setting a different browser as my default browser (tried Brave, Chrome and Edge)
- Clearing browser cache
- Tried putting the link into Excel not as a formula (just as a straight hyperlink) and same issue
- I put the mentioned registry key from the help article in a similar address that I did have (HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Internet)
- Poked around in my registry to see if I could find anything similar to the registry key mentioned and kept coming up empty.
Anyone have any suggestions for me? Thanks in advance.
Edition Windows 10 Pro
Version 20H2
Installed on 8/23/2020
OS build 19042.928
Experience Windows Feature Experience Pack 120.2212.551.0
Microsoft Excel for Microsoft 365 MSO Version 2103 Current Channel 16.0.13901.20436 (64-bit)
- JKPieterseSilver ContributorTo what do these links refer exactly? Word documents? PDF's?
- bjerniganCopper ContributorThey refer to URL on a website
- JKPieterseSilver Contributor
Ok. If you haven't got that reg key, you could try to just create it at the location advised. It should go under the 16 branch if you are using office 365