Apr 26 2021 07:23 AM
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-c...) 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:
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)
Apr 26 2021 07:34 AM
Apr 27 2021 08:22 AM
Apr 27 2021 10:41 AM - edited Apr 27 2021 10:42 AM
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
Apr 28 2021 02:06 PM
Apr 29 2021 02:25 AM
Apr 29 2021 07:10 AM
@Jan Karel Pieterse Thank you, that didn't quite do it but it lead me on a hunt for more details related to this topic and finally found one comment buried deep in a forum that suggested to create this entire registry string even if it did not exist. Here is the final answer that solved my problem https://social.technet.microsoft.com/Forums/en-US/128cb772-6745-412b-8a9f-af555fac1eb0/huperlink-doe... go all the way down to the very last comment by user boossy.
Basically you need to add the entire registry string even if it does not exist and you also have to both locations:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\9.0\Common\Internet
In both places create a DWORD (32-bit) named ForceShellExecute with a value 1
Apr 29 2021 08:53 AM - edited Apr 29 2021 08:53 AM
That was exactly what I was trying to say :)
Glad you were able to solve the problem!