Fix Excel for Mac SharePoint Link Showing Local File Path
Question details
The user wants to link Excel workbooks using universal SharePoint URLs on a Mac, ensuring the links work for all team members sharing the file.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Changing or creating links to external workbooks that are stored in a synced SharePoint document library.
- Observed behavior
- Excel for Mac automatically generates local file paths (e.g., Users/Name/...) instead of the expected SharePoint web URLs, breaking the link for other users.
Ensure you have the latest version of the OneDrive sync app installed on your Mac and that your SharePoint document library is actively syncing to your local Finder.
Update Links via OneDrive Sync and Refresh
Select the linked file from your synced Finder folder, then save and reopen the workbook to force Excel to convert the local path to a SharePoint URL.
When selecting a file from a synced SharePoint folder via Finder, macOS passes the local file directory to Excel. Excel is designed to recognize the synced folder and convert this local path to the corresponding SharePoint web URL upon saving.
Open the OneDrive sync app on your Mac and ensure that the target SharePoint document library is fully synced and accessible via Finder.
Open your primary workbook in Excel for Mac. Go to the 'Data' tab and click on 'Edit Links' to modify the source file.
In the file browser dialog, navigate to your synced SharePoint folder in Finder and select the target workbook. The path may temporarily appear as a local directory.
Save the Excel workbook, close the application completely, and then reopen the file. Check the 'Edit Links' menu again to see if the local path has successfully updated to the SharePoint URL.
Try WPS Office for Seamless Cross-Platform File Sharing
If Excel for Mac's local path syncing issues are disrupting your team's workflow, consider switching to WPS Office. It provides robust spreadsheet management with built-in cloud collaboration tools, eliminating localized link errors.
Frequently Asked Questions
Why does Excel for Mac show a local path instead of a SharePoint link?
When you select a file using the macOS Finder, the system naturally passes a local file path to the application. While Excel is programmed to translate synced OneDrive/SharePoint paths into web URLs upon saving, bugs in the Mac version of Excel frequently interrupt this translation process.
Can I manually paste the SharePoint URL into the Excel link source?
While you can edit standard hyperlinks directly, external workbook data connections usually require selecting the file via the operating system's file browser. Manually typing a URL into the 'Change Source' dialog on a Mac often results in an invalid file path error.
How do I report this local path issue to Microsoft?
If the problem persists across multiple devices and saving/reopening does not convert the links, you should contact your organization's IT department. The Microsoft 365 tenant administrator can open an official support ticket through the Microsoft 365 admin center.
