Adding hyperlinks to an Excel sheet makes it easier to access related information or navigate to specific sections within a large workbook. Using hyperlinks, you can make your spreadsheet interactive and organize your data efficiently. But what if these hyperlinks stop working or responding in Microsoft Excel? Whether it's a broken link or Problem with Excel applicationFixing the issue shouldn't take long on your Windows 10 or 11 computer. Here are some tips that should help you fix hyperlinks not working in Microsoft Excel on Windows.
1. Double-check the link path.
It's possible that the file path mentioned in the hyperlink is no longer accessible, or the web page link is misspelled. Therefore, you'll need to check the hyperlink for any spelling errors.
In addition, if The associated file name contains a pound sign (#).Excel may display the error “The specified file cannot be opened.” To fix this problem, you should Rename the file that you are trying to hyperlink and remove the pound sign (#) from its name. After renaming the file, update the hyperlink in Excel to reflect the new file name.
2. Check the auto-correct options for hyperlinks.
Excel's AutoCorrect feature can: Automatically converts certain types of text entries, such as Internet and network paths, to hyperlinks. However, if this feature is turned off, your hyperlinks may appear as plain text in Microsoft Excel. To avoid this, you must allow Excel to automatically replace Internet and network paths with hyperlinks.
Step 1: Open Microsoft Excel On your computer, click the menu. "a file" in the upper left corner.
Step 2: Locate Options from the left sidebar.
Step 3: in the tab "Audit" Click the button Autocorrect options.
Step 4: Under the tab “Auto format as you type”, select the checkbox Internet and network paths with hyperlinks. Then click OK.
3. Prevent Excel from updating links
When you enable the "Update links on save" feature, Microsoft Excel automatically updates links to other workbooks, charts, and websites when you save a workbook. However, This feature may sometimes break hyperlinks. In your Excel workbook. You can turn this feature off to see if it resolves your issue.
Step 1: Open Microsoft Excel On your computer, click the menu. "a file" in the upper left corner.
Step 2: Locate Options from the right part.
Step 3: in Advanced tabScroll down to tap Web Options.
Step 4: Under the tab "files", Uncheck the option “Update links when saving”. Then click OK to save the changes.
4. Disable Protected View
Many Office applications, including Excel, include a Protected View feature that protects your computer from opening links or files that could be malicious. This feature can sometimes accidentally open perfectly secure Excel files in Protected View, limiting your ability to access embedded links. If you're confident in the legitimacy of a document, you can temporarily disable Protected View in Excel to avoid such problems.
Step 1: Open Microsoft Excel Click on the menu "a file" in the upper left corner.
Step 3: Switch to tab 180 years old Click the button Trust Center Settings.
Step 4: in the tab “Protected Offer”Uncheck the three check boxes to disable it. “Protected Offer” And click "OK" to save the changes.
5. Repair Excel workbook
Are hyperlinks not working only in a specific Excel workbook? If so, the problem may be related to the file itself. Fortunately, Excel includes a repair feature that can automatically identify and fix problems in your workbook. Here's how to use it.
Step 1: Open Microsoft Excel Click on the menu "a file" in the upper left corner.
Step 3: Browse and select Excel file Yours. Then click down arrow Next to open to select option "Conquest and Reform".
6. Run the Office Repair Tool.
If all else fails, consider running the Microsoft Office Repair Tool as a last resort. This tool can automatically repair problems in all Office applications, including Excel. Here's how to run it.
Step 1: Right click on start icon and select Installed apps from the list.
Step 2: Scroll down to locate your Microsoft Office product in the list. Click Three horizontal dots menu icon located next to it and select Modify.
Step 3: Select Quick Fix and click repair.
If the hyperlinks still don't work, repeat the process to perform the online repair. This may take longer, but it will likely resolve the issue.
Navigate smoothly with working hyperlinks.
Hyperlinks are a great way to save time and effort when working in Microsoft Excel. Sometimes, they can leave you frustrated when they fail to work, but that's something you can't fix with the solutions above.
