Fix Excel OneDrive Links That Update Only When the Source Workbook Opens
Question details
The user needs Excel links to OneDrive for Business workbooks to update when the source files are closed.

- 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.
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.
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.
Open the OneDrive or SharePoint library and confirm that each affected user can open the linked source workbooks with their own account.
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.
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.
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.
In the master workbook, select Formulas > Calculation Options > Automatic. Then use Update Values in Workbook Links or Edit Links and check the linked cells.

Review external formulas and refresh with the source open
Use this workaround if access and link paths are correct but the master workbook still returns blanks or errors.
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.

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.




