Limitations of the Break Links command in Excel 2003 and in Excel 2002 (291984)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Office Excel 2003
This article was previously published under Q291984

SUMMARY

Microsoft Office Excel 2003 and Microsoft Excel 2002 include a new 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. On the Edit menu, click Links.

    NOTE: The Links command 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

Modification Type:MinorLast Reviewed:5/12/2006
Keywords:kbinfo KB291984
©2004 Microsoft Corporation. All rights reserved.