Excel: Unexpected Values Returned When Defined Name Referenced

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.

KBCategory: kbother
KBSubcategory:
Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

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