Microsoft KB Archive/268974

= XL2000: Name Cannot Be Applied to Formulas on All Sheets in a Workbook =

Article ID: 268974

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q268974





SYMPTOMS
In Microsoft Excel 2000, you are able to create a name to represent a formula or a constant value.

However, when you attempt to apply a name to a formula that references a formula or a constant value on a different worksheet, you receive the following error message:

Microsoft Excel cannot find any references to replace.



CAUSE
In Excel, a name may be applied only to the worksheet that contains the formulas that the name has been defined to reference.

Keywords: kbprb KB268974

-

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

© Microsoft Corporation. All rights reserved.