When you work on a large file which contains link from different files, the file size becomes large and removing the link by searching different links may be difficult.
To remove these link easly and to make the linked contents as paste special values you can follow these steps.
· Go to Data tab and click on Edit links.
· You can see the different source files linked to this workbook.
· Select the file you want to remove the link and click on Break Link
· It will remove the link and keep only values.