It sounds like you are experiencing a common issue with breaking links in Excel. Here are a few steps you can try to break the link successfully:
- Make sure that the workbook containing the link is open and that the link is not currently being used in any formulas or charts.
- Try breaking the link from the Edit Links window again, but this time, instead of clicking on "Break Links," try clicking on "Check Status" to see if there are any issues with the link that need to be resolved before it can be broken.
- If the above steps do not work, try manually removing the link from any formulas or charts in your workbook. To do this, select the cell or chart that contains the link, and then edit the formula or chart data to remove the reference to the external workbook.
- Save and close your workbook, and then reopen it to see if the link has been successfully broken. If you still receive the security alert, try saving the workbook under a new name to see if that resolves the issue.
If none of these steps work, it may be necessary to seek additional assistance from a technical support professional or from the person who created the link in the first place. Good luck!