How to Update Excel Links When Moving from Network Drive to SharePoint
Question details
A company is migrating Excel workbooks from mapped network drives to SharePoint and needs to update existing formulas and links that reference the old drive letters.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Migrating company files from local mapped network drives to cloud-based SharePoint document libraries.
- Observed behavior
- Existing formulas and external links in Excel workbooks break or reference incorrect paths because they point to old mapped network drive letters instead of the new SharePoint locations.
Ensure you have the OneDrive sync client installed on your computer and verify that you have edit permissions for the newly created SharePoint document libraries. It is highly recommended to back up your original Excel files before updating external links en masse.
Synchronize SharePoint Document Libraries with OneDrive
Syncing SharePoint via OneDrive maps the cloud files to a local directory, making it easier for Excel to resolve linked workbooks using local paths instead of complex web URLs.
OneDrive synchronization is generally more reliable than attempting to map SharePoint as a traditional network drive. It allows users to access files locally while ensuring changes sync to the cloud automatically.
By keeping interconnected workbooks in the same relative folder structure within the synced OneDrive directory, Excel can often maintain link integrity without requiring manual updates.
Navigate to the target SharePoint document library using your preferred web browser and log in with your credentials.
Click the 'Sync' button located in the top command bar of the SharePoint interface to launch the OneDrive sync client on your computer.
Allow OneDrive to create a local folder on your computer containing the synced SharePoint files. This folder will appear in your File Explorer.
Open your master Excel workbook from the newly created local synced folder. Check your formulas to verify if Excel automatically resolved the relative links based on the local folder structure.
Manually Update Workbook Links to SharePoint URLs
If you do not use the OneDrive sync client or if links remain broken, you must manually point the network drive links to the new SharePoint web URLs.
Struggling with Complex Link Migrations? Try WPS Office
If migrating interconnected Excel workbooks to complex cloud ecosystems feels overwhelming, WPS Office offers a free, lightweight alternative. Enjoy seamless compatibility with all Microsoft Excel formats and manage your interconnected spreadsheets locally or via WPS Cloud without the hassle of broken network mappings.
Frequently Asked Questions
If a file is synced with OneDrive and opened in the desktop app, will it be locked for other users?
No, when opening a OneDrive-synced file in a modern desktop client with auto-save enabled, co-authoring allows multiple users to edit simultaneously. It will not be locked like a file on a legacy network drive.
Does OneDrive Sync replace the ability to map network drives for SharePoint files?
Yes, Microsoft heavily recommends using the OneDrive sync client instead of mapping network drives. OneDrive sync is significantly more reliable, supports offline file access, and integrates better with modern authentication methods.
Why do my Excel formulas show a '#REF!' error after moving to SharePoint?
The '#REF!' error occurs because Excel cannot find the linked source file at the original mapped network drive path (e.g., Z:\finance\budget.xlsx). Updating the link source to the new SharePoint location or syncing the library locally will restore the values.
