SharePoint Document Issues

Fix Word Hyperlink to Specific Excel Cell in SharePoint Not Working

Steve K Sep 30, 2026 869 views

Question details

The user needs a hyperlink embedded in a Word document to successfully direct readers to a specific target cell within an Excel file hosted on SharePoint.

How to Fix a Word Link to a Specific Excel Cell in SharePoint That Does Not Work

Product: Microsoft Word, Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Clicking a hyperlink in a Word document intended to jump directly to a designated cell in a SharePoint-hosted Excel workbook.
Observed behavior: The Excel workbook opens at its last saved location instead of navigating to the specifically linked cell.

Before you start

Ensure you have the necessary viewing or editing permissions for the SharePoint file and that you are signed in with the same Microsoft 365 account across all your Office applications.

Solution 1Recommended

Generate the Link from the Excel Desktop App

This method ensures the hyperlink is generated with the exact cell reference directly from the desktop application connected to SharePoint.

Sometimes the hyperlink path copied manually or generated improperly loses the specific range reference when transitioning between Word and SharePoint.

Open Excel via SharePoint

Launch the Microsoft 365 desktop app. Go to File > Open > SharePoint, and open your target Excel workbook.

Copy the Range Link

Right-click on the specific cell or range you want to link to, and select 'Copy Link to the Range' from the context menu.

Test the Link in a Browser

Paste the copied link directly into your web browser's address bar and press Enter to verify it successfully navigates to the specific cell.

Embed the Link in Word

Once verified, open your Word document, highlight the text you want to hyperlink, press Ctrl+K, paste the copied link into the address field, and click OK.

Generate the Link from the Excel Desktop App

Link Verification: Testing the link in a web browser first helps isolate whether the issue lies with the link formatting or how the Word application handles it.

Solution 2

Create the Cell Link Using Excel for the Web

If the desktop app fails to generate a working URL, utilizing Excel for the Web often creates a more reliable web-based hyperlink structure.

Solution 3

Isolate the Issue Using Word's Copy Hyperlink Feature

Use this diagnostic step to determine if Word is modifying the hyperlink upon clicking.

Free Microsoft Office alternative

Enjoy Seamless Document Linking with WPS Office

If complex SharePoint integrations and Microsoft Office web links are disrupting your workflow, WPS Office provides a reliable, lightweight, and free alternative. It easily manages offline and local cross-document hyperlinks without the syncing bugs found in cloud environments.

1. Download WPS Office: Visit the official WPS Office website to download the free installation package.
2. Install the Software: Run the installer and follow the simple on-screen instructions to set up the suite on your device.
3. Manage Documents Effortlessly: Open your .docx and .xlsx files directly in WPS Office to experience fast, seamless cross-document linking and editing.

Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Reliably handles inter-document hyperlinks for local and shared files.Free alternative to costly Microsoft 365 subscriptions.Lightweight installation with a familiar, user-friendly interface.

microsoft office alternative - wps office

Frequently Asked Questions

How do I link to a specific cell in a local Excel workbook instead of SharePoint?

To link to a specific cell in a local Excel workbook, create a hyperlink in Word, select the target Excel file, and manually append a hashtag, the sheet name, an exclamation mark, and the cell reference to the file path (e.g., Book1.xlsx#Sheet1!A1).

Why do my SharePoint Excel links keep opening in the browser instead of the desktop app?

This behavior is controlled by your SharePoint document library settings or local Office settings. You can change the default open behavior by going to Library Settings > Advanced Settings in SharePoint, and selecting 'Open in the client application'.

Does WPS Office support linking from a text document to a spreadsheet cell?

Yes, WPS Office fully supports standard hyperlink features. You can easily insert a hyperlink in a WPS Writer document that points directly to a specific cell or named range in a WPS Spreadsheets file.

Document & File Issues