VBA & Macro Problems

Fix Excel Hyperlinks Not Working After Switching Worksheets in Macro-Enabled Workbooks

Camila Milosovich Sep 30, 2026 868 views

Question details

The user is experiencing an issue where a website hyperlink in an Excel workbook stops functioning after navigating to a different worksheet and returning.

How to Fix Excel Hyperlinks Not Working After Switching Worksheets

Product: Microsoft Excel
Device & OS: not provided
Scenario: Clicking a website hyperlink in a macro-enabled (.xlsm) workbook after switching between different worksheets or viewing another customer record.
Observed behavior: The hyperlink works perfectly immediately after insertion but becomes unresponsive once the user changes worksheets, despite Trust Center settings already being reviewed.

Before you start

Before troubleshooting, ensure you create a backup copy of your current macro-enabled workbook to prevent any accidental data loss while modifying VBA code or saving in different file formats.

Solution 1Recommended

Isolate the Issue by Saving as a Macro-Free Workbook

Test if the problem is caused by background VBA scripts by converting the file to a standard .xlsx format, which automatically disables all macros.

Because the workbook is macro-enabled, it is highly likely that a VBA script or background macro is interfering with the hyperlink's clickability. Saving the file in a macro-free format will help isolate whether the issue lies within the code or the Excel application itself.

Open the original file

Open your problematic macro-enabled workbook (.xlsm) in Excel.

Save as a macro-free format

Navigate to 'File' > 'Save As', choose a destination folder, and select 'Excel Workbook (*.xlsx)' from the 'Save as type' dropdown menu.

Test the hyperlink

Open the newly saved .xlsx file, insert a hyperlink, switch to another worksheet, and return to check if the link remains clickable.

Isolate the Issue by Saving as a Macro-Free Workbook

Diagnostic Outcome: If the hyperlink functions correctly in the .xlsx file, you have confirmed that the issue is directly caused by the VBA code or worksheet events in your original .xlsm file.

Solution 2

Inspect Worksheet Events and VBA Code for Conflicts

Identify and temporarily disable specific VBA macros that might be altering hyperlink behavior when sheets are deactivated or activated.

Free Microsoft Office alternative

Try WPS Office for Seamless Workbook and Spreadsheet Management

If Microsoft Excel continues to experience hyperlink freezing or VBA conflicts that disrupt your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible environment for managing spreadsheets without unexpected freezing or complex macro bugs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheets and open your .xlsm or .xlsx file.
3. Navigate Smoothly: Click on your hyperlinks and switch between worksheets to enjoy a smooth, conflict-free spreadsheet experience.

Free to use with a clean, intuitive, and familiar interfaceHighly compatible with Microsoft Excel formats, including .xlsx, .xlsm, and .csvStable handling of web hyperlinks and cross-sheet navigationLightweight application that runs smoothly on most devices without heavy resource consumption

microsoft office alternative - wps office

Frequently Asked Questions

Why do hyperlinks stop working only in macro-enabled (.xlsm) workbooks?

This usually occurs because a background VBA script, such as a Worksheet_Deactivate or Worksheet_SelectionChange event, overrides default cell behaviors, clears the clipboard, or locks the worksheet when you navigate away and return.

Does Excel's Trust Center affect hyperlink clickability?

Yes, strict Trust Center settings can block external links or macro execution. However, if you have already reviewed Trust Center settings and the link still fails after switching sheets, the issue is likely rooted in active VBA code rather than security policies.

How can I get help with specific VBA code causing this hyperlink bug?

You can post a reproducible version of your VBA code on developer forums like Stack Overflow. Make sure to use the 'VBA' and 'Excel' tags, and clearly explain the steps that trigger the hyperlink failure.

Excel & Data Problems