Fix Excel Hyperlinks Working Online but Not in Desktop App
Question details
Internal worksheet hyperlinks in a shared Excel workbook function correctly in Excel for the web but are unresponsive or unavailable in the Excel desktop application.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Clicking internal worksheet hyperlinks within a shared SharePoint workbook using the Excel desktop application.
- Observed behavior
- Links are unclickable or partly unavailable in the desktop application, despite working flawlessly in Excel for the web. This behavior varies across different users on the same Office version.
Verify that your internet connection is stable and you are signed into the correct Microsoft 365 account, ensuring the shared SharePoint workbook is fully synced to your local desktop.
Recreate Hyperlinks and Isolate the Workbook Issue
Test if the issue is specific to the workbook by creating a new file, and recreate broken links using the correct internal linking method.
Because this workbook is shared on a SharePoint team site, the internal link paths may become corrupted or desynced for certain users. Isolating the issue helps determine if the Excel app or the specific workbook is at fault.
Create a new Excel workbook locally and upload it to the SharePoint site. Add a few test references to other worksheets within this new file.
Open the test workbook in both Excel for the web and the Excel desktop application. Have other affected users click the links to see if the issue persists in the new file.
If the new workbook works correctly, open the original problematic workbook. Right-click the broken hyperlink, select 'Edit Link' (or 'Insert Link'), choose 'Place in This Document' on the left panel, and reselect the target worksheet.

Clear Local Office Cache and Disable Add-ins
Clear corrupted temporary cache files and disable third-party add-ins that might interfere with Excel's hyperlink functionality.
Update Office and Repair the Shared Workbook
Ensure your Excel application is fully up-to-date and use the built-in repair tool to fix underlying structural corruption in the shared file.
Use WPS Office for Reliable Spreadsheet Management
If you frequently encounter syncing issues and broken hyperlinks with Microsoft Excel desktop apps, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling shared spreadsheets seamlessly without hyperlink errors.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software suite.
- 2. Open your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
- 3. Manage Links Flawlessly: Use the familiar 'Insert Link' feature to navigate between worksheets instantly.

Frequently Asked Questions
Why do hyperlinks behave differently for users on the same Office version?
Even if the Office version is identical, individual users can experience different behaviors due to corrupted local Office cache files, conflicting third-party COM add-ins installed on their machine, or slight desyncs between their local app and the SharePoint server.
How do I correctly link to another worksheet in the same Excel file?
To create an internal link, select the cell, press Ctrl+K (or right-click and select Link), choose 'Place in This Document' from the left panel, and then select the specific worksheet and cell reference you want to link to.
Does repairing the Excel workbook fix hyperlink issues?
Yes. If a shared workbook has been heavily edited, its internal XML structure can become slightly corrupted. Using Excel's built-in 'Open and Repair' feature can often rebuild this structure and restore missing or unclickable hyperlinks.
Will hyperlinks created in Excel for the web always work in the desktop app?
Usually, yes. However, if a link uses a web-based absolute URL instead of an internal document reference ('Place in This Document'), the desktop app might struggle to resolve it locally, leading to unclickable links.




