XL: Cannot Evaluate 3-D References Using F9 KeyLast reviewed: September 13, 1996Article ID: Q116116 |
The information in this article applies to:
SUMMARYIn Microsoft Excel, if you attempt to evaluate part of a formula by pressing the F9 key, you will receive a #REF! error if a 3-D reference is contained within the evaluated section. Microsoft Excel cannot evaluate 3-D references in this way.
MORE INFORMATIONMicrosoft Excel allows you to evaluate part of a formula in order to see how that part of the formula is handled when the formula is entered. To see how this feature of Microsoft Excel works, do the following:
|
KBCategory:
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |