Update Or Remove Broken Link To Excel. You can also solve this problem by going to the Excel Options to check an option please do as follows. If an external link to a source is contained within a cell formula the link will disappear from the list.
I want to fix the link so they point at the linked excel file but the MS support document is out of date. Select the link and click on the break links option. On the Data tab in the Queries Connections group click the Edit Links button.
You can also solve this problem by going to the Excel Options to check an option please do as follows.
Head to the workbook which contains the broken link creating the problem. Unfortunately this command is difficult to find. In the Edit Links dialog box select the links that you want to break. If this button is greyed out that means there is no linked data in your workbook.