Microsoft KB Archive/49276

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Excel: Unexpected Values Returned When Defined Name Referenced

Last reviewed: October 31, 1994
Article ID: Q49276


If a name is defined using relative referencing, unexpected results can occur in cells referencing that named cell.

When relative references are used in a defined name, the reference is relative to any cell containing a formula that uses that name. If it is used in a dialog box, such as the Go To dialog, it is relative to the active cell. This is the correct function of relative references.

To avoid this ambiguity, use absolute references in defined names.

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.