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:
Save the file to a new name (like MyFile1.xls).
Hit EditŕLinks and choose to link it to
- Save it, close it.
- 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