If you think this may be the root of the problem, the only thing you can do is to recreate the hyperlinks.
#How to fix broken hyperlinks in excel 2016 update
Clear the Update Links on Save check box.The Files tab of the Web Options dialog box. Excel displays the Web Options dialog box. The Advanced options of the Excel Options dialog box. Scroll through the available options until you see the General section.If Microsoft Edge is not your default browser, click the Make default button at the top. From the left navigation, select Default browser. Press Alt + f to open the browser menu options. You can delete multiple lists at a time using SHIFT. To make Microsoft Edge your default browser, Open Microsoft Edge. Click on the list for deletion & click on Delete. Click on Name Manager or Press CTRL + F3 shortcut key. To delete unwanted or useless named ranges. You will be able to see all the named ranges with sheet names & the linked cells. At the left side of the dialog box click Advanced. Select any blank cell & Press F3, and then click on Paste List.In Excel 2010 and Excel 2013 display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. If you want to cut to the chase, the last 15 seconds shows the bad stuff. I have taken a video showing me importing data into a clean workbook from adventure works (Access). (There have been some reports that Excel disables the links a bit too early sometimes, which could be the behavior that Fanie is seeing.) Do this by following these steps: Power Query in Excel 2016 has stopped working for me. If that is not the problem, you may want to turn off an option in Excel that causes the program to check hyperlinks whenever the workbook is saved. If this is the case, you will need to either change the name of the worksheet back to its original name, or you will need to recreate the hyperlinks to point to the renamed worksheet. If you later rename the worksheet, then the hyperlinks may not work as expected. When you create hyperlinks, each of them references the name of the worksheet you specify as the target. Check to make sure that you didn't rename the second worksheet-the one that is the target of the hyperlinks.
First, you need to make sure that the problem isn't due to something you inadvertently did in your workbook. The second time the hyperlinks were all gray and would no longer work, and she's at a loss as to why this occurred.
Those hyperlinks worked fine until Fanie saved and reopened the workbook. In the first worksheet she created hyperlinks to the second worksheet.
Fanie has a workbook with two worksheets.