Calculation Issues

Fix Excel OneDrive Links That Update Only When the Source Workbook Opens

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

The user needs Excel links to OneDrive for Business workbooks to update when the source files are closed.

Fix Excel OneDrive Links That Update Only When the Source Workbook Opens
Product
Microsoft Excel and OneDrive for Business
Device & OS
not provided
Scenario
A master workbook contains external formulas linked to source workbooks in a OneDrive for Business library.
Observed behavior
Linked cells remain blank or show errors until the source workbooks are opened, even though the link status reports OK and Update Values has been used.
Before you start

Identify the source workbooks and confirm that each user can open them from the OneDrive or SharePoint library. Use desktop Excel for the link checks and note whether the files are opened from the web or a synchronized local folder.

Solution 1Recommended

Check access, synchronization, and workbook link sources

Use this approach when links point to OneDrive for Business files but do not refresh while the source workbooks are closed.

1
Verify source access

Open the OneDrive or SharePoint library and confirm that each affected user can open the linked source workbooks with their own account.

2
Check local synchronization

If you use synchronized files, check the OneDrive sync status in the system tray or menu bar. In the local OneDrive folder, make sure the master and source workbooks are available on the device.

3
Inspect the link source

Open the master workbook in desktop Excel and select Data > Workbook Links or Data > Edit Links, depending on your version. Check that each source points to the intended workbook; use Change Source if the path is incorrect.

4
Recreate a test link

Open a source workbook from the synchronized folder or SharePoint library. In the master workbook, select a test cell, type an equals sign, select the source cell, and press Enter. Save both workbooks, close the source, and test the link.

5
Update and recalculate

In the master workbook, select Formulas > Calculation Options > Automatic. Then use Update Values in Workbook Links or Edit Links and check the linked cells.

Check access, synchronization, and workbook link sources
A source workbook may still need to be open: A link status of OK does not guarantee that every formula can calculate against a closed source. If a tested link still fails, open the source workbook before updating the master.
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format support, making it easy to move everyday workbook tasks to WPS. It does not fix Excel's OneDrive link behavior.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for formulas and workbook reviewsWork with a free, lightweight Office alternativeMove existing Office files into WPS without starting from scratch
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel report that a link is OK but leave the cells blank?

The source may be reachable while a particular formula or link configuration still cannot calculate with the source closed. Check the formula bar, then open the source workbook and select Formulas > Calculate Now in the master.

Where can I change a workbook link in Excel?

In desktop Excel, open the master workbook and select Data > Workbook Links or Data > Edit Links. Select the source and use Change Source to point it to the intended workbook.

Should I use a SharePoint URL or a local OneDrive path?

Use a path that users can access consistently, and test it in desktop Excel. If using local paths, confirm that the relevant library is synchronized and the source files are available on each user's device.

Can I create or manage these links in Excel for the web?

External workbook link capabilities vary by Excel version and environment. For this troubleshooting process, open both workbooks in desktop Excel and use Data > Workbook Links or Edit Links.