File Sharing Problems

How to Create SharePoint File Links in Excel for All Users

Khadija Khan Oct 21, 2026 868 views

Question details

The user wants to ensure that hyperlinks to SharePoint files within an Excel workbook open correctly for all coworkers, instead of failing due to local path dependencies.

How to Create SharePoint File Links in Excel for All Users

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook containing hyperlinks to SharePoint files with colleagues.
Observed behavior: Hyperlinks fail to open for coworkers because the links point to a local OneDrive path (e.g., C:\Users\...) specific to the creator's machine rather than a universally shared web address.

Before you start

Ensure that the SharePoint files you intend to link to have the appropriate viewing or editing permissions granted to your coworkers. You will also need access to the web version of your SharePoint document library to copy the correct URLs.

Solution 1Recommended

Replace Local OneDrive Paths with SharePoint Web URLs

Update the hyperlinks in your Excel file to use the direct web address of the SharePoint files, ensuring anyone with permissions can access them.

When you create a link to a file synced via the OneDrive desktop client, Excel defaults to your computer's local path. Because your coworkers do not have the same local user folders, the link breaks. Using the web URL forces the browser or application to authenticate and route the user correctly.

Locate the file in SharePoint web

Open your web browser, navigate to your SharePoint site, and locate the target file or folder you want to link to.

Copy the shareable link

Click the 'Share' icon next to the file, or click 'Copy link', to generate a web URL that colleagues can access.

Edit the hyperlink in Excel

Open your Excel workbook, right-click the cell containing the broken hyperlink, and select 'Edit Hyperlink' from the context menu.

Paste the web URL

In the 'Address' field at the bottom of the dialog box, delete the local C:\Users\ path, paste the copied SharePoint web URL, and click 'OK'.

Replace Local OneDrive Paths with SharePoint Web URLs

Permission Check: By using the web URL, coworkers will automatically be prompted to sign in and authenticate with their own permissions when clicking the link.

Solution 2

Automate Link Generation via Power Automate

For larger environments or extensive document lists, use Power Automate to dynamically generate and manage shared links without manual copying.

Manage Spreadsheets Efficiently

Create and Manage Web Hyperlinks Seamlessly with WPS Spreadsheet

WPS Office provides a lightweight, highly compatible spreadsheet tool that makes it easy to insert, manage, and share web URLs, ensuring your team can access cloud files without frustrating local path errors.

1. Open your workbook: Launch WPS Office and open your spreadsheet. Select the cell where you want to insert the cloud file link.
2. Access the hyperlink tool: Go to the 'Insert' tab on the top ribbon and click on 'Hyperlink', or simply press Ctrl+K on your keyboard.
3. Select the link type: In the dialog box, ensure that 'Existing File or Web Page' is selected on the left panel.
4. Insert the web URL: Paste the shared web URL of your SharePoint file into the 'Address' bar at the bottom and click 'OK'.

Fully compatible with Microsoft Excel (.xlsx) formats and hyperlink structures.Easily insert and manage web URLs for cloud-based SharePoint file sharing.Lightweight software with a familiar, easy-to-navigate user interface.Cost-effective solution with powerful built-in collaboration features.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel hyperlinks automatically change to local C:\Users\ paths?

This occurs because the OneDrive desktop sync client maps your cloud files to a local directory on your PC. When you link directly to a synced file using your local File Explorer, Excel captures your specific local file path instead of the universal cloud URL.

Can I fix multiple broken local links in Excel at once?

Yes. If all files reside in the same SharePoint directory, you can use the 'Find and Replace' feature (Ctrl+H) in Excel. Search for your local path prefix (e.g., C:\Users\YourName\OneDrive\) and replace it with your SharePoint site's root URL path.

Do my coworkers need a specific account to open the SharePoint link?

It depends on the link sharing settings you configured in SharePoint. If you generated an 'Anyone with the link' URL, no login is required. If the link is restricted to 'People in your organization', they will need to authenticate with their corresponding company accounts.

Document & File Issues