Problem with Hyperlinks in Excel (10,13) with Windows 10  


  1. Posts : 3
    Windows 10
       #1

    Problem with Hyperlinks in Excel (10,13) with Windows 10


    I have a multi tab Excel spreadsheet. I can open any of the tabs, hyperlinks on my Windows 7 system without problems On Windows 10, I get the warning message: Some files can contain viruses or otherwise be harmful to your computer ... I find my Microsoft sites that describe this problem and have suggested adding a registry item.

    \HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Security
    DWORD: DisableHyperlinkWarning 1

    That does not correct the problem. I m hoping that someone else out there has seen this and has a solid solution

    Thanks

    - - - Updated - - -

    Will do.... Always want to give credit to a helping person(s)
      My Computer


  2. Posts : 1,164
    W10-Pro 22H2
       #2

    Is this for links to specific file types, or just web pages? I have had fun with links to pdf files (locally stored), and if that is it may be able to help.
      My Computer


  3. Posts : 11,246
    Windows / Linux : Arch Linux
       #3

    Hi there

    I think this method should work depending on which office version you are using -- try the first solution rather than messing about with registry edits.

    How to disable Hyperlink Warnings for Office programs

    I've got no probs with hyperlinks --- works perfectly in EXCEL 2019 (PRO X-64)

    Problem with Hyperlinks in Excel (10,13) with Windows 10-excel.png

    Cheers
    jimbo
      My Computer


  4. Posts : 3
    Windows 10
    Thread Starter
       #4

    My EXEC is Office 2016. It does not contain the same uncheck boxes as yours indicated. I do have the item in the Registry for DisableHyperlinkWarning set to 1. Still no difference I get that warning message anytime I open a hyperlink

    My spreadsheet has hyperlinks which open other Excel files in the same directory. So its opening another existing file. The same spreadsheet works fine on Windows 7 with Office 2010
      My Computer


  5. Posts : 2
    windows 10
       #5

    After the early July 2020 major Windows 10 update my excel hyperlinks no longer work and I get a "Your organization's policies are preventing us from completing this action for you" notice instead... any solutions please?
      My Computer


  6. Posts : 565
    Windows 10 Professional 64-bit
       #6

    Sparkz8 - Is Firefox your default browser? If so try the following. I got it from somewhere on the internet and it worked for me: -

    Problem message "This Operation has been canceled due to restrictions in effect on this computer. Please contact your administrator" in Excel 2010 (win 7) when try to open a hyperlink. Opening links within emails is not an issue. It is only from within Excel docs that the problem arises.

    Just ran across this problem myself after upgrading from Firefox 32-bit to Firefox 64-bit v55.x. The result is that the Windows registry "forgets" how to open a hyperlink. You need to modify the registry as follows: -
    HKEY_CLASSES_ROOT:
    • .htm, .html, .shtml, .xht, .xhtml keys were all set with a (Default) REG_SZ value of "FirefoxHTML" or “Value not set” (without quotes).
    • the FirefoxHTML key, however, had no instruction for opening a FirefoxHTML doc type
    • so I simply had to add these registry keys/values: -

    Windows Registry Editor Version 5.00

    [HKEY_CLASSES_ROOT\FirefoxHTML\shell\open]
    Enter value: - @="&Open"

    [HKEY_CLASSES_ROOT\FirefoxHTML\shell\open\command]
    Create the “command” key, then in it: -
    Enter value: - @=""C:\\Program Files\\Mozilla Firefox\\firefox.exe" -osint -url "%1""

    [HKEY_CLASSES_ROOT\FirefoxHTML\shell\open\ddeexec]
    Create the “ddeexec” key

    This provided a clear open instruction.

    Firefox 64-bit may have added a new class key "FirefoxHTML-308046B0AF4A39CB", which did have an "shell\open" subkey, which I used as source for reg entries, above.
    Sticking to my policy of minimal necessary registry change, simply adding the FirefoxHTML\shell\open... subkey was the minimal change that I needed to make.
    If problem reoccurs then check the registry entries above to see if they have been changed.
      My Computers


  7. Posts : 2
    windows 10
       #7

    Thanks Wiganken for your help, though I'm not a techi and the idea of mucking about with the registry spooks me. I'm amazed that it is so complicated to fix a simple issue which you would of thought MS would have realised since the update and issued a patch to fix the problem as excel is so common.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 14:07.
Find Us




Windows 10 Forums