How to Fix Excel Hyperlinks to Shared Files Not Working for Other Users
Question details
Users are encountering errors when attempting to open hyperlinks in an Excel file that point to documents stored in a shared network folder.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook where cells contain HYPERLINK formulas or inserted links pointing to other files on a shared network drive.
- Observed behavior
- When other users click the hyperlink, they receive an error stating that the file path is not specified, preventing them from accessing the linked file.
Ensure that all collaborating users have the necessary Windows network folder permissions to view and access the destination shared folder.
Use UNC Paths Instead of Mapped Drive Letters
Replacing local mapped drive letters with Universal Naming Convention (UNC) paths ensures the hyperlink works regardless of individual user drive configurations.
A common reason hyperlinks break for other users is that the link uses a mapped drive letter (like Z:\) which might not be mapped on their computer, or might be mapped to a different network location.
Find the full network server and share name for the file (e.g., \\ServerName\SharedFolder\Document.xlsx).
Right-click the cell containing the broken link in Excel and select 'Edit Hyperlink'.
In the Address field at the bottom of the dialog box, delete the mapped drive path and paste the full UNC path.
Click 'OK' to confirm the change and save the Excel file.
Ensure Consistent Drive Mapping Across All Users
If you must use mapped drives, every user accessing the Excel file needs to have the network drive mapped to the exact same letter.
Disable 'Update Links on Save' in Web Options
Excel sometimes automatically converts absolute network paths into relative paths when saving, which breaks links for other users. Disabling this feature preserves your absolute paths.
Create and Share Reliable Spreadsheets with WPS Office
WPS Spreadsheet makes collaborating on shared network files effortless. With robust support for UNC paths and accurate hyperlink preservation, you can ensure your team always has uninterrupted access to linked documents without dealing with frustrating path errors.
- 1. Open your shared workbook: Launch WPS Spreadsheet and open the shared document your team is working on.
- 2. Insert the hyperlink: Right-click the target cell and choose 'Hyperlink' from the context menu.
- 3. Enter the universal path: Type the full absolute UNC network path into the address bar to guarantee access for everyone.
- 4. Save and share: Save your work. WPS Office securely preserves the link formatting for other users on your network.
Frequently Asked Questions
What is a UNC path and why is it better for shared Excel files?
A UNC (Universal Naming Convention) path specifies the exact network location of a file using the server and share name (e.g., \\ServerName\Folder\File.xlsx) rather than a local drive letter. It is much better for shared files because it doesn't depend on every user having mapped the network drive to the exact same letter on their individual computers.
Why does Excel change my absolute hyperlink to a relative one?
By default, Excel tries to be helpful by updating hyperlinks on save to make them relative to the workbook's current location. However, this often breaks links if the workbook is accessed via different mapped network drives. You can stop this behavior by disabling 'Update links on save' in File > Options > Advanced > Web Options.
Can file permissions cause a 'file path not specified' hyperlink error?
Yes. Even if your hyperlink path is formatted perfectly using a UNC path, if the user clicking the link does not have the proper Windows folder permissions to read the destination file on the network server, Excel will fail to follow the link and may throw an error.
