XL2000: Copying Worksheet into Workbook Deletes Defined Name

• Microsoft Excel 2000

SYMPTOMS

When you copy a worksheet into a workbook, existing defined names may be deleted. Formulas that refer to the deleted defined names return the #NAME? error.

CAUSE

This problem occurs if the following conditions are true:

• You copy a worksheet from one workbook to another workbook.
  
  -and-



• The worksheet that you copy contains a reference to a defined name that does not exist.
  
  -and-



• The worksheet that you copy contains a chart.
  
  -and-



• The workbook to which you copy the worksheet contains the same defined name that is referred to on the sheet that is copied.

STATUS

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

Additional query words: XL97

Keywords : kbdta xlui xlformula
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug