Fix Excel External Links That Use Local OneDrive Paths
Question details
The user needs shared Excel workbooks to refresh external links without depending on another user's local OneDrive path.

- Product
- Microsoft Excel and OneDrive for Business
- Device & OS
- Windows; version not provided
- Scenario
- A team shares interrelated Excel workbooks stored in OneDrive for Business or SharePoint.
- Observed behavior
- Some external links are saved with a path under another user's C:\Users folder, preventing other users from refreshing the linked data.
Confirm that both the source and destination workbooks are in a shared OneDrive or SharePoint location and that the other user has permission to open them. Use desktop Excel for the test, and close the source workbook before checking the saved link.
Check and reconnect the external workbook link in desktop Excel
Use this approach to inspect a link, reconnect it to an accessible source, and test whether another user can refresh it.
Excel can store or display link paths differently depending on how the workbooks were opened and where they are stored. There is no confirmed setting that forces every external link to be saved as a OneDrive or SharePoint URL.
Opening files from a synchronized folder or from the web does not guarantee a particular link format. Verify the result with another user's account rather than relying on the displayed path alone.
In OneDrive or SharePoint, open both the source and destination workbooks with Open in desktop app. Confirm that the destination formula refers to the intended source workbook.
Save the destination workbook, close the source workbook, and select Data > Workbook Links or Data > Edit Links in desktop Excel. Check whether the listed source points to a local user folder or the intended shared location.
Select the link and choose Change source, if available. Browse to the intended source workbook in an accessible shared location, select it, and save the destination workbook. The available options and resulting path can vary by Excel version and how the file was opened.
Ask another user to open the destination workbook in desktop Excel from the shared location. In Data > Workbook Links or Edit Links, select the source and use Refresh or Update Values, then confirm that the expected values appear.
Work with Excel-compatible files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move existing files into a new workflow. It does not repair Microsoft Excel's OneDrive link behavior.

Frequently Asked Questions
Is there a setting that always saves Excel external links as OneDrive URLs?
There is no confirmed setting that guarantees this for every workbook link. After creating or changing a link, close the source workbook and inspect the link under Data > Workbook Links or Data > Edit Links.
Why can I refresh a link when a colleague cannot?
The link may reference a path under your Windows user folder that does not exist on your colleague's computer. Check the source in Data > Workbook Links or Edit Links, and confirm your colleague can open the shared source workbook.
Will opening both files from OneDrive guarantee a portable link?
No. The saved or displayed path can vary with the opening method and workbook location. Save the destination, close the source, and have another user open and refresh the destination in desktop Excel.
Can I refresh these links in Excel for the web?
Excel for the web supports some workbook-link scenarios, but support and refresh behavior can vary by feature and configuration. Test the specific workbook in the browser and use desktop Excel if the required link behavior is unavailable.




