Microsoft KB Archive/147949

= XL7: Defined Names Deleted After Opening Dependent Workbook =

PSS ID Number: 147949

Article Last Modified on 10/20/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q147949





SYMPTOMS
In Microsoft Excel, when you delete a worksheet containing a defined name that is shared with another workbook, all the defined names in the source workbook may be deleted after the dependent workbook tries to update the links.



CAUSE
This problem occurs when a dependent document has links to non-existent sheets in a source file and the dependent document also contains chart objects.



WORKAROUND
To work around this around this problem, do the following:
 * Break the links between the dependent document and the source document before you delete the sheet containing the defined name.
 * Avoid deleting a sheet containing a defined name that is linked to a chart object.
 * Avoid including charts in the dependent workbook.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Keywords: KB147949

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

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

© 2003 Microsoft Corporation. All rights reserved.