Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 291984 - Last Review: January 31, 2007 - Revision: 3.1
Limitations of the Break Links command in Excel
This article was previously published under Q291984
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.
To use the
Break Links command, follow these steps:
- 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. - In the Edit Links dialog box, click Break Links.
- When you are prompted to confirm that you want to break the
links, click Break Links.
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=293418/
)
Frequently asked questions about using links in Excel 2002 and in later versions of Excel
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate