SharePoint Document Issues

Fix Excel SharePoint Hyperlink Opening Folder Instead of File

John WilsonJohn Wilson Oct 22, 2026 869 views

Question details

The user needs to fix an issue where clicking a hyperlink in Excel intended to open a specific file on SharePoint opens the parent folder instead.

Fix Excel SharePoint Hyperlinks Opening the Folder Instead of the File
Product
Microsoft Excel
Device & OS
not provided
Scenario
Clicking cell hyperlinks in an Excel workbook connected to SharePoint documents.
Observed behavior
The hyperlink incorrectly navigates to the SharePoint folder or document library directory instead of directly launching the target file, such as a PDF or PowerPoint presentation.
Before you start

Ensure you have the correct view and access permissions for the target file in SharePoint, and verify that the file has not been recently renamed or moved to a different directory.

Solution 1Recommended

Recreate the Hyperlink Using the Direct SharePoint File URL

The most common cause of this issue is linking to the document library instead of the specific file. Copying and replacing the link with the direct file URL resolves this.

When you copy a URL from the browser address bar while viewing a SharePoint library, you are often copying the folder's view link, not the file's direct path. To ensure Excel opens the file directly, you must extract the exact file link.

1
Locate the file in SharePoint

Open your web browser, navigate to your SharePoint document library, and locate the exact file (e.g., PDF, PowerPoint) you want to link.

2
Copy the direct link

Click the 'Show Actions' icon (three vertical dots) next to the file name and select 'Copy link'. Ensure the link settings are configured for direct file access rather than folder access.

3
Edit the Excel hyperlink

Go back to your Excel spreadsheet, right-click the cell containing the broken hyperlink, and select 'Edit Hyperlink' from the context menu.

4
Paste the correct URL

In the 'Address' field at the bottom of the dialog box, delete the old URL, paste the newly copied direct file link, and click 'OK'.

Recreate the Hyperlink Using the Direct SharePoint File URL
Verification: Click the newly edited hyperlink in Excel to confirm it now opens the specific file directly instead of the SharePoint folder.
Efficient Spreadsheet Management

Easily Manage Cloud and Local Hyperlinks in WPS Spreadsheet

WPS Office offers a straightforward way to add, edit, and manage hyperlinks to both local documents and cloud-hosted files. Avoid complex pathing issues by using WPS Spreadsheet to securely link your PDFs, PowerPoint presentations, and emails with precise URL routing.

  1. 1. Open your document: Launch WPS Spreadsheet and open the workbook where you want to insert or manage hyperlinks.
  2. 2. Access hyperlink settings: Select the target cell, right-click, and choose 'Hyperlink' from the menu, or simply press 'Ctrl + K'.
  3. 3. Insert the direct file URL: In the 'Address' field, paste the direct URL to your cloud file (ensuring it points directly to the file extension like .pdf or .pptx) and click 'OK'.
Highly compatible with Microsoft Excel (.xlsx) formats and standard hyperlink structures.Intuitive hyperlink management interface to quickly bind web URLs to spreadsheet cells.Seamless support for web-based URLs, ensuring your cloud files open correctly.Lightweight installation with a clean, user-friendly interface that is completely free.
microsoft office alternative - wps office

Frequently Asked Questions

Why do local hyperlinks work in Excel, but SharePoint hyperlinks open the folder?

Local file paths point directly to a specific file extension on your hard drive. In contrast, SharePoint URLs can sometimes default to the document library or folder view if the 'Share' link was generated for the directory context rather than the absolute path of the specific file.

How do I get the direct URL of a file in SharePoint instead of the folder link?

In SharePoint, locate your specific file, click the three vertical dots (Show Actions) next to it, and select 'Copy link'. You can also click on the file to open it in the browser and copy the URL directly from the address bar, ensuring it includes the specific file extension.

Can I use the HYPERLINK() formula function for SharePoint files?

Yes, you can use the HYPERLINK() function for SharePoint files. However, you must ensure the URL string within the formula is the exact direct path to the file, and that users clicking the link have the necessary SharePoint permissions to view the file.