Microsoft KB Archive/277602

= When you break the link to an object in a shared workbook, the source list in other shared workbooks is not updated in Excel =

Article ID: 277602

Article Last Modified on 2/7/2007

-

APPLIES TO


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

-



This article was previously published under Q277602





SYMPTOMS
When you break a link to an object in a shared workbook, the link is still displayed in the Source list in the Edit Links dialog box of that same shared workbook.

When you insert an object that is linked to a data source in another workbook into a shared workbook, and then break the link to that object from another instance of that shared workbook, the following behavior occurs:
 * The link is broken in the workbook, and the source object is no longer displayed in the Source list in the Edit Links dialog box.
 * When you save and close the workbook, and then open the workbook again, you no longer receive the Update Links message.
 * The formerly linked object still appears in the Source list in the Edit Links dialog box.



WORKAROUND
To work around this issue, break the link in the other instance of the shared workbook. To do this, follow these steps:

NOTE: To make sure that the links are deleted correctly, make sure that no other users have the shared Excel workbook open while you perform these steps.
 * 1) On the Edit menu, click Links.

Note In Microsoft Office Excel 2007, click Edit Links in the Connections group on the Data tab.
 * 1) In the Edit Links dialog box, click Break Link, and then click Break Links in the Microsoft Excel message box that appears.
 * 2) Click Close.
 * 3) On the File menu, click Save.

Note In Excel 2007, click the Microsoft Office Button, and then click Save.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbprb kbtshoot kbexpertisebeginner kbbug kbpending KB277602

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.