File Sharing Problems

Fix Excel Formula Links Changing to SharePoint URLs on OneDrive

Bushra ParveenBushra Parveen Oct 22, 2026 870 views

Question details

Excel formulas referencing an external workbook automatically change their source reference to a SharePoint or OneDrive URL when the source file is closed.

How to Handle Excel Links Between Workbooks on OneDrive and SharePoint
Product
Microsoft Excel
Device & OS
not provided
Scenario
Working with multiple linked Excel workbooks synchronized through OneDrive or stored on SharePoint.
Observed behavior
Formula links work normally and show standard paths when both files are open, but the reference path switches to a long SharePoint URL immediately after closing the source workbook.
Before you start

Ensure you are signed into your Microsoft account and that your OneDrive or SharePoint sync client is fully updated and actively syncing before troubleshooting link behaviors.

Solution 1Recommended

Manage and Update Cloud Link References

Understand that the URL reference change is expected behavior for cloud-hosted files and learn how to update these links properly.

When Excel files are stored on OneDrive or SharePoint, the application automatically converts local file paths to web URLs. This ensures that external links remain valid for other users collaborating online, even if they sync files to different local directories.

This is a built-in feature, not a software bug. While the URL formula looks significantly longer, it does not bloat or increase the file size. Keep in mind that updating these external references over the internet may take slightly longer than local updates.

1
Open the main workbook

Launch Microsoft Excel and open your primary workbook that contains the external formulas.

2
Navigate to link settings

Go to the 'Data' tab on the top ribbon and click on 'Edit Links' located within the Queries & Connections group.

3
Update the references

Select the listed links showing the SharePoint URL and click the 'Update Values' button to securely pull the latest data from the closed source workbook.

Manage and Update Cloud Link References
Expected Behavior: The formula will automatically revert to displaying just the standard workbook name and cell reference whenever you open the source workbook alongside your main file.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If managing forced URL conversions and complex external references in Microsoft Excel becomes frustrating, consider trying WPS Office. It provides a lightweight, highly compatible alternative for handling spreadsheets smoothly.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install the software: Run the downloaded installer and follow the straightforward on-screen instructions to complete the setup.
  3. 3. Manage your spreadsheets: Launch WPS Spreadsheet, easily open your existing .xlsx files, and manage your external links seamlessly.
Free and lightweight office suiteExcellent compatibility with Microsoft Excel (.xlsx) formats and external link formulasFamiliar user interface makes switching effortlessStable local file management without unexpected path changes
microsoft office alternative - wps office

Frequently Asked Questions

Why is updating external links on OneDrive slower than with local files?

When links reference a SharePoint or OneDrive URL, Excel must fetch the data over the internet directly from the cloud server rather than your local hard drive. The speed of this update depends entirely on your current internet connection and network latency.

Will the long SharePoint URL in my formula increase the Excel file size?

No. The URL simply replaces the local file path as a text string within the formula's structure. This text substitution has a completely negligible impact on the overall size of your workbook.

How can I stop Excel from changing local file paths to SharePoint URLs?

To retain strict local file paths, you must store the workbooks in standard folders outside of any OneDrive or SharePoint sync directories. Whenever files are saved in cloud-synced folders, Excel automatically uses web URLs to maintain link integrity for shared online collaboration.