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