Microsoft KB Archive/49276

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:56, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.