A hyperlink is a useful feature.
However, many users reported that they cannot open hyperlinks in Excel.
Received the oops message Were sorry but Excel has run into an error while opening Excel?
Now get rid of it by reading this article.
How to Fix Excel Hyperlinks Not Working in Windows
Solution 1.
Here is the guide you’re able to follow.
Open an Excel file.
Click onFile>Options>Advanced.
Scroll down to find and clickWeb Options.
Move on to theFilessection, and uncheck theUpdate links on saveoption.
Then clickOKto apply your change.
Check whether the issue has been fixed.
Solution 2.
In this case, it’s crucial that you recreate or edit the link with the updated one.
InFile Explorer, copy the link of the file from the address bar.
In Excel, right-smack the hyperlink and clickEdit Hyperlink(Or you might clickRemove Hyperlinksand then recreate it).
In the address box, input the new location path and clickOK.
Now the Excel hyperlink should be activated.
Solution 3.
Solution 4.
Repair Microsoft Office
The last way is torepair Microsoft Office.
Do you know how to deal with the Microsoft Office something went wrong issue?
If not, this post shows you several useful ways to help you get rid of it.
In various situations, Excel file loss happens from time to time.
Can you recover deleted or lost Excel files?
The answer is Yes.
Here thebest data recovery software MiniTool Power Data Recovery is recommended to you.
Here you’re free to see the major steps to recover Excel files.
Download, install, and launch MiniTool Power Data Recovery.
MiniTool Power Data Recovery FreeClick to Download100%Clean & Safe
Step 2.
In the main interface of this tool, pick the target partition containing your Excel files and clickScan.
Step 3. you might stop the scan process if you find the wanted files by previewing them.
Then check all needed files and clickSaveto choose a file storage location separate from the original one for them.
Hope the methods mentioned above are beneficial to you.