Microsoft KB Archive/49276

{| = Excel: Unexpected Values Returned When Defined Name Referenced =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q49276

SUMMARY
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.
 * }