+ Reply to Thread
Results 1 to 9 of 9

How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    32

    Post How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    I've read that there is an issue when inserting hyperlinks in Excel 2016 and I seem to be having this issue. I am looking for how to work around this.

    I have an Excel sheet with data and want to link the document number entered in Excel to link to the corresponding form. When adding the hyperlinks, Excel freezes as soon as I get the "Insert Hyperlink" window. I then have to control-alt-delete to get out of Excel. This is with Windows 10, version 1709, and Office 2016. Is there any way to work around this issue? Any suggestions? Thanks!!!

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    I have an Excel sheet with data - this I understand

    I want to link the document number entered in Excel to link to the corresponding form - what are you trying to do here?

    - what & where is the document number?
    - what & where is the corresponding form?

    How are you trying to add hyperlinks ?
    - by funcion(=HYPERLINK) OR right click \Insert Hyperlink

    Could you upload a simple example workbook:
    UploadWorkbooks.jpg

    thanks
    Last edited by kev_; 01-08-2018 at 11:20 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    Document Status Chart Upload.xlsx

    Thanks for your help. I was using the right-click "insert hyperlink". The hyperlink function freezes Excel as well. I have attached a sample worksheet.

    My issue is not how to add the hyperlink. It is that Excel freezes with the hyperlinks added to the point the whole program is unusable and the mouse is frozen.

    Thanks again!!!

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    I think it is simply that Excel cannot interpret your links

    Here is one example from your file - the address Excel cannt find is:
    \\MASTERFS\JobsForUS\Order-Drain Sampling valves\Job 17-48.04, Petrofac UAE\07 - Quality\Document Transmittals\SUBMITTED\11-30-17\KHF-00-PPFP058-ZV-A01-00001_03.docx


    Quickly try putting a file on your C drive and linking to it there
    - the link address should then look like this:
    C:\TestArea\KHF-00-PPFP058-ZV-A01-00001_03.docx

    If that works then you have proven that Excel is working as it should, and that the problem resides in the link address

  5. #5
    Registered User
    Join Date
    10-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    All the links I am using are valid links and link to a server and the corresponding document. I can link to a program on my desktop or to any document and it does link. Problem is that Excel then freezes and makes the entire Excel program unusable. I can wait for anywhere from 3 to 10 minutes waiting for Excel to unfreeze. Once it unfreezes, as soon as I move the mouse anywhere in the program or across the screen, Excel freezes again. It freezes whether I have one link or 5 links. It freezes when I have only one link that links to another cell in the same document. It freezes as soon as I reopen the document (I have also re-created the document from scratch thinking the doc was corrupt somehow). Excel freezes when I open any document that has hyperlink(s).

    Thanks for your suggestions. Is this the first you have heard of it? No one has asked about this before me?

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    I am running Excel 2016 and Windows 10 and do not experience this problem ever
    - if you unhook your PC from the server and then try the link, does Excel still freeeze?
    - my suspicion is that that the problem only occurs when you are hooked into a server (which would provide a small clue)

    I have not personally seen this specific issue come up before but I only look at a small proportion of the threads in my spare time
    - I will have a look around later and see what I can dredge up in earlier threads

  7. #7
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    Is this link relevant to you - one of the microsoft updates in late 2017 caused a hyperlinking issue

  8. #8
    Registered User
    Join Date
    10-09-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    From what I have read, it has to do with the Fall Creators Update, version 1709, that became available in November 2017. Since that update, hyperlinks have been a problem. All updates have been installed since the previous update.

  9. #9
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: How to Work-Around Known Issue? Adding Hyperlinks Freezes Excel 2016

    For the sake of troubleshooting try the following:

    Create a .txt file with a character/word in it and save someplace local like desktop or my documents.

    Open a new blank Excel file and using Insert | Hyperlink from the ribbon (NOT context menu) try and hyperlink to the file you created above.

    If it doesnt crash click the link to ensure it works. If it works then it is likely an issue specific to your file or what/where you are linking to. I would then copy the txt file to the same place as the files you actually want to link to and try again, in this fashion you can troubleshoot if its Excel, the location of the source file etc.

    If it crashes, close Excel and open it in safe mode. Start a new blank file and repeat attempting the link as above. If it works its either an addin or a template causing the issue. We would then disable all addins in normal mode and attempt the linking as above (blank file/txt source) and see if it works. If so enabling addins 1 by 1 until it does not. Tehn you know which addin is the issue. If it doesnt work with all disabled you try a clean template.

    If it doesnt work after the above I would recommend a repair on office. You may consider uninstalling Office and reinstalling if that doesnt resolve it (after having tried the above).

    You can also check Windows event viewer and see if the freeze/crash causes a logged error. May shed light on why its crashing.
    Last edited by Zer0Cool; 01-08-2018 at 05:01 PM.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2016 issue with ExecuteExcel4Macro?
    By kuno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2017, 09:29 AM
  2. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  3. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  4. Excel 2016 Hyperlinks Won't Open
    By drew.lewis.rtr in forum Excel General
    Replies: 4
    Last Post: 08-17-2017, 12:25 AM
  5. [SOLVED] Adding Hyperlinks to the names of sheets - the formula doesn't work
    By Vitalite in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-23-2017, 08:20 AM
  6. [SOLVED] wrong hyperlinks in excel 2016 workbook
    By doronwin in forum Excel General
    Replies: 3
    Last Post: 05-24-2017, 05:07 AM
  7. Replies: 1
    Last Post: 08-24-2016, 03:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1