File Format & Compatibility

Fix Blank Pages When Copying Excel SharePoint Hyperlinks

Tauseeq Magsi Sep 30, 2026 868 views

Question details

A SharePoint PDF hyperlink functions correctly in the original Excel workbook but fails and opens a blank page in the web browser after being copied to a different workbook.

How to Fix Blank Pages When Copying Excel SharePoint Hyperlinks

Product: Microsoft Excel
Device & OS: not provided
Scenario: A user is copying cells containing hyperlinks that point to PDF files stored on SharePoint from one Excel workbook to another.
Observed behavior: When clicking the copied hyperlink in the destination workbook, the web browser opens a blank page instead of loading the targeted PDF file.

Before you start

Ensure you are logged into your Microsoft 365 account in your default web browser and have the necessary SharePoint permissions to access the linked PDF document.

Solution 1Recommended

Compare and Verify Hyperlink Formulas

Ensure that the destination workbook is retaining the exact URL structure and not modifying it into a relative path upon copying.

Excel has a feature that sometimes updates links upon saving or copying, which can convert absolute URLs into relative paths. This often breaks SharePoint document links when they are moved to a new workbook environment.

Inspect the Original Link

Right-click the working hyperlink in the original Excel workbook and select 'Edit Hyperlink' to view the exact address.

Inspect the Copied Link

Right-click the broken hyperlink in the second workbook and select 'Edit Hyperlink'.

Compare and Correct

Compare the two addresses side-by-side. If the copied link has been altered or shortened, manually paste the full SharePoint URL from the first workbook into the address field of the second workbook and click 'OK'.

Using the HYPERLINK Function: To prevent Excel from automatically altering link paths when copying between workbooks, consider using the HYPERLINK function formula instead of standard cell hyperlinks (e.g., =HYPERLINK("Your_SharePoint_URL", "Click Here")).

Solution 2

Escalate to Microsoft 365 Support

Because this hyperlink behavior can depend heavily on the specific Microsoft 365 tenant environment, administrator-level troubleshooting may be required.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Management

If you frequently encounter environment-specific bugs, link conversion issues, or heavy dependency problems in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible and lightweight alternative for managing complex spreadsheets and external references without the hassle.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the Software: Run the downloaded installer and follow the on-screen instructions to quickly set up the office suite on your device.
3. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files to enjoy seamless hyperlink functionality and robust data management.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsHandles hyperlinks and external file references reliably between documentsLightweight application with fast launch speeds and low system resource usageFamiliar user interface ensures a zero-learning-curve migration

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel hyperlinks change when copied to another workbook?

Excel often attempts to update links upon saving or copying by converting absolute URLs into relative paths based on the workbook's file location. You can disable this behavior by opening Excel Options, going to 'Advanced', clicking 'Web Options', and unchecking 'Update links on save'.

How do I force Excel to keep the exact SharePoint URL?

Instead of inserting a standard hyperlink via the right-click menu, use the HYPERLINK function formula. By typing =HYPERLINK("exact_sharepoint_url", "Link Text"), you ensure that Excel treats the URL as a static string, preventing it from being auto-formatted or broken when copied.

What causes a SharePoint link to open a blank page in the browser?

A blank page typically occurs if the copied link has been truncated, converted incorrectly into a local relative path, or if the browser session is lacking the necessary authentication tokens to resolve the specific SharePoint Document ID.

Document & File Issues