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?

Best Fixes to We’re Sorry but Excel Has Run Into an Error

Now get rid of it by reading this article.

Solution 1.

Here is the guide you’re able to follow.

uncheck Update links on save

Open an Excel file.

Click onFile>Options>Advanced.

Scroll down to find and clickWeb Options.

How to Fix Microsoft Excel Cannot Paste the Data Error

Move on to theFilessection, and uncheck theUpdate links on saveoption.

Then clickOKto apply your change.

Check whether the issue has been fixed.

edit hyperlink

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.

3 Ways to Fix Microsoft Office Something Went Wrong

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.

scan the target drive

Solution 3.

Solution 4.

Repair Microsoft Office

The last way is torepair Microsoft Office.

save all needed files

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.