Question: how do i permanently delete links in excel?
Answer: On the Data tab, in the Connections group, click Edit Links. Note: The Edit Links command is unavailable if your file does not contain linked information.
In the Source list, click the link that you want to break. To select multiple linked objects, hold down the CTRL key, and click each linked object. ... 
Click Break Link.