I was recently presented with an Excel file which displayed a message every time it was opened indicating that it contained links to other files. I was assured by the owner of this spreadsheet that all links had been removed.

Thanks to officearticles.com for helping me to solve the problem:

  • Open the file with the problematic link in (MyFile.xls in this example).
  • Save the file to a new name (like MyFile1.xls).
  • Select Edit >Links and choose to link it to MyFile.xls.
  • Save it and close.
  • Delete MyFile.xls and rename MyFile1.xls to become MyFile.xls again.

Of course if you have Excel 2003 or later you can just select Edit > Links and there is a Break Link button in the dialog box!