Popular Pages

Share

 

 

 

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.

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved