Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows

Free Downloads    ¨   Suggest an Article    ¨    Fix an Article
 

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.

All contents copyright Anne Troy 2005-2006