If your workbook contains a link to data in a workbook or other file that you moved to another location, you can fix the link by updating the path of that source file. If you can't find or don't have access to the document that you originally linked to, you can prevent Excel from trying to update the link by turning off automatic updates or removing the link.
Important
Linked objects aren't the same as hyperlinks. The following procedure doesn't fix broken hyperlinks. To learn more about hyperlinks, see Create or edit a hyperlink.
Fix a broken link in Excel for Mac
Caution
This action can't be undone. You might want to save a backup copy of the workbook before you begin this procedure.
If your workbook uses Power Query (Get Data), manage and refresh data sources in the Queries & Connections pane instead of Workbook Links.
Open the workbook that contains the broken link.
If you see a yellow warning, "Unable to refresh. We couldn't get updated values from a linked workbook," select Manage Workbook Links.
Or, on the Data tab, select Workbook Links.
The Workbook Links command is unavailable if your workbook doesn't contain links.
In the Workbook Links box, select the broken link that you want to fix.
Note
To fix multiple links, hold down
, and then click each link.Select More … > Change Source.
Browse to the location of the file containing the linked data.
Select the new source file, and then press Select.
Select Refresh to update the source data into the target workbook.
Remove a broken link in Excel for Mac
When you break a link, all formulas that refer to the source file are converted to their current value. For example, if the formula =SUM ([Budget.xls]Annual!C10:C25) results in 45, the formula is converted to 45 after you break the link.
Open the workbook that contains the broken link.
On the Data tab, select Workbook Links.
The Workbook Links command is unavailable if your workbook doesn't contain links.In the Workbook Links box, select the broken link that you want to delete.
Note
To remove multiple links, hold down
, and then click each link.Select More … > Break Links.
If your data source is stored in OneDrive or SharePoint, make sure you have access to the file and that the path or link didn't change.
