XL: Cannot Evaluate 3-D References Using F9 Key

ID: Q116116

The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a

SUMMARY

In 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 INFORMATION

Microsoft 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:

  1. In a new worksheet, enter the following values:
    A1: 1 B1: =SUM(A1:A3)
    A2: 2
    A3: 3


  2. Select cell B1.


  3. In the formula bar, select A1:A3.


  4. Press the F9 key.


Note that the "A1:A3" disappears and is replaced by "{1;2;3}". This indicates that the range A1:A3 is evaluated to the array of values 1, 2, and 3. (To return to editing mode, press the ESC key.)

Additional query words: three dimensional 3D

Keywords :
Version : 5.00 5.00c 7.00 7.00a
Platform : WINDOWS
Issue type :


Last Reviewed: September 16, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.