Fix Broken Links to Another Workbook in Excel Online
Question details
Repair external links between workbooks that appear broken when the destination workbook is opened in Excel Online.
- Product
- Microsoft Excel Online
- Device & OS
- not provided
- Scenario
- The user needs a workbook to retrieve data from another Excel workbook stored in a shared or cloud location.
- Observed behavior
- External references do not update or cannot find the source workbook in Excel Online.
Confirm the name and current cloud location of the source workbook, and make sure you can open both workbooks with the same Microsoft account. Excel Online has limited external-link editing support, so use a desktop spreadsheet app to repair the reference.
Repair the external workbook link in desktop Excel
Use this method when an Excel Online workbook shows a broken reference after its source workbook was moved, renamed, or replaced.
Repairing external workbook references in desktop Excel updates the saved workbook relationship. After you save and synchronize the corrected file, Excel Online can use the updated reference when the source file and permissions are available.
In OneDrive or SharePoint, locate the source workbook and confirm that it has not been deleted, renamed, or moved to a different folder or site.
From Excel Online, select Open in Desktop App, or download and open the destination workbook in the Microsoft Excel desktop application.
In desktop Excel, select the Data tab and choose Edit Links. Select the broken source workbook in the list.
Select Change Source and browse to the current source workbook, or select Update Values if the listed source path is already correct. Confirm that the link status no longer reports an error.
Select File > Save, then allow OneDrive or SharePoint to synchronize the workbook. Reopen it in Excel Online and verify that the linked values are available.
Restore access to the linked workbook in OneDrive or SharePoint
Use this method when the source file exists but Excel Online cannot open or update it because of sharing or location restrictions.
Update External Workbook Links with WPS Spreadsheets
WPS Spreadsheets can open Excel workbooks, help you review external references, and save a corrected workbook after you update the linked source file. Use it as a lightweight desktop option when an online workbook needs link maintenance.
- 1. Open the affected workbook: Launch WPS Spreadsheets and select Open to open the workbook that contains the broken external reference.
- 2. Locate the external reference: Select the Data tab and use the available link or connection management options to review the workbook's external source reference.
- 3. Set the current source workbook: Choose the option to change or update the source, then browse to and select the workbook in its current local or synchronized cloud folder.
- 4. Confirm the linked values: Refresh or update the linked data, then check the relevant cells to confirm that the external reference returns values instead of an error.
- 5. Save the repaired workbook: Select Menu > Save or press Ctrl+S, then synchronize or upload the saved workbook to OneDrive or SharePoint.
Frequently Asked Questions
Why do links to another workbook break in Excel Online?
Links commonly break when the source workbook was renamed, moved, deleted, or placed in a location the current user cannot access. Excel Online can also have limitations when updating certain external workbook links.
Where can I change an external workbook link in desktop Excel?
Open the destination workbook in desktop Excel, then select Data > Edit Links. Select the source workbook and choose Change Source to point the link to the current file location.
Do both linked workbooks need to be in OneDrive or SharePoint?
For reliable access in Excel Online, store both workbooks in accessible OneDrive or SharePoint locations. The user opening the destination workbook must also have permission to open the source workbook.
Can Excel Online repair a broken workbook link by itself?
Not always. If the source path must be changed or the online app does not support the link operation, open the workbook in desktop Excel, use Data > Edit Links, save it, and then let the corrected version synchronize.
