OneDrive File Issues

Fix Excel External Links That Use Local OneDrive Paths

Bushra ParveenBushra Parveen Nov 20, 2026 868 views

Question details

The user needs shared Excel workbooks to refresh external links without depending on another user's local OneDrive path.

Fix Excel External Links That Use Local OneDrive Paths
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the shared workbooks

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.

2
Inspect the link

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.

3
Reconnect if necessary

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.

4
Test with another user

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.

If the link still uses an inaccessible path: Check the other user's permissions and how both files were opened, then repeat the test. Consistent OneDrive sync locations may help some teams, but they do not guarantee portable links. Excel for the web support for workbook links can vary by feature and configuration, so verify web behavior separately.
Free Microsoft Office alternative

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.

Open and edit spreadsheets with familiar workbook toolsCompatible with Microsoft Excel XLS and XLSX formatsReview spreadsheet formulas and linked workbook contentUse a free, lightweight Office suite for everyday work
microsoft office alternative - wps office

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.