Fix Excel Local Links Not Working After SharePoint Upload
Question details
Users need a way to preserve or fix Excel hyperlinks pointing to absolute local file paths (e.g., C:/Users/...) that break after the workbook and linked files are uploaded to SharePoint.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Uploading an Excel workbook containing hyperlinks to local files into a SharePoint document library.
- Observed behavior
- The Excel links stop working because they still point to local C: drive paths, which SharePoint cannot resolve or open.
Ensure that both your Excel workbook and all linked files have been successfully uploaded to the same SharePoint library before attempting to repair the hyperlinks.
Recreate Links Using OneDrive Synchronization
Synchronize your SharePoint document library to your local computer using OneDrive to safely recreate relative links that work for all users.
SharePoint web environments cannot access or resolve absolute links pointing to a local C: drive. By syncing the SharePoint library to your local machine via OneDrive, you create an environment where Excel can establish relative paths that remain intact when synced back to the cloud.
Open the SharePoint document library in your web browser and click the 'Sync' button in the top toolbar to connect it to your local OneDrive app.
Open File Explorer, locate your newly synced SharePoint/OneDrive folder, and ensure both your Excel workbook and the linked target files are placed inside this folder structure.
Open the Excel workbook from the synchronized folder, right-click a broken hyperlink, and select 'Edit Hyperlink'. Browse to the target file within the same synced folder and click 'OK'.
Experience Seamless Spreadsheet Collaboration with WPS Office
Avoid complex SharePoint sync setups and frequent broken link issues. WPS Office provides a lightweight, highly compatible alternative with its own built-in WPS Cloud, making file sharing and hyperlink management straightforward and secure.
Frequently Asked Questions
Why do my Excel links change to file:///C:/ when uploaded to SharePoint?
When you create a hyperlink to a file on your computer, Excel stores it as an absolute path pointing to your local drive. Because the SharePoint web environment is cloud-based, it cannot access your local C: drive, causing these specific local paths to fail.
Does Excel automatically convert local links to SharePoint web links?
No, Excel does not automatically convert local absolute paths to web URLs during an upload. You must use OneDrive synchronization to establish relative paths or manually edit the links to point to the new SharePoint URLs.
How can I prevent hyperlinks from breaking when sharing files?
To prevent broken links, always save your workbook and all target files in the same folder or subfolder before creating the hyperlinks. This encourages the spreadsheet application to generate relative paths instead of absolute local paths.
Will repaired synced links work for my colleagues?
Yes. If you recreate the links using a synced OneDrive/SharePoint folder, Excel creates relative paths. As long as your colleagues have permissions to access the same SharePoint library, the links will resolve correctly for them.
