Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/250825

From BetaArchive Wiki
Knowledge Base


XL2000: Copying Worksheet into Workbook Deletes Defined Name

Article ID: 250825

Article Last Modified on 11/5/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition



This article was previously published under Q250825


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.


RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.


Additional query words: XL97

Keywords: kbbug kbfix KB250825