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!