You are currently offline, waiting for your internet to reconnect

Limitations of the Break Links command in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q291984
SUMMARY
Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 include a feature that allows you to break external links within a workbook. However, the Break Links command cannot break the following types of links:
  • A defined name that refers to an external workbook
  • A ListBox control with an input range that refers to an external workbook.
  • A DropDown control with an input range that refers to an external workbook.
MORE INFORMATION
To use the Break Links command, follow these steps:
  1. In Excel 2003 or in Excel 2002, click Links on the Edit menu.

    In Excel 2007, on the Data tab, click Edit Links in the Connections group.

    Note The Links command or the Edit Linkscommand is only available if the workbook contains links.
  2. In the Edit Links dialog box, click Break Links.
  3. When you are prompted to confirm that you want to break the links, click Break Links.
REFERENCES
For more information how to work with links in Excel, click the following article number to view the article in the Microsoft Knowledge Base:
293418 Frequently asked questions about using links in Excel 2002 and in later versions of Excel
delete remove xl2002 office xp xl2003
Properties

Article ID: 291984 - Last Review: 01/31/2007 19:02:03 - Revision: 3.1

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition

  • kbinfo KB291984
Feedback
/html>p;did=1&t=">