Removing Links in Microsoft Excel


There are several methods, depending on your version.

In Excel 2003, you can choose Edit Links from the menu. Then choose Break Link.

In lesser versions, you can try this trick:

  1. Save the file to a new name (like MyFile1.xls).

  2. Hit Edit Links and choose to link it to MyFile.xls.
  3. Save it, close it.
  4. Delete MyFile.xls and rename MyFile1.xls to become MyFile.xls again.

There's also an add-in called findlinks.xla that's been around a long time, and you can download it here. Please be sure to read all of the instructions so you understand how to use it.