Excel Will Not Translate Lotus 3-D ReferenceLast reviewed: November 3, 1994Article ID: Q68499 |
The information in this article applies to:
SYMPTOMSMicrosoft Excel for Windows does not retain a formula that references an array of data where the array(s) includes more the one sheet (ply) of a Lotus 3-D cube. Only the corresponding value comes across correctly.
STATUSThis problem has been corrected in Microsoft Excel version 4.0.
MORE INFORMATIONThis is not a problem with Microsoft Excel. Microsoft Excel does not handle 3-D referencing and alerts you that it can't read a 3-D reference when you try to open a Lotus sheet with a 3-D reference. Microsoft Excel brings across the corresponding values correctly and also generates a note in the cell in which the 3-D reference was located. The note states that the "Formula Failed to Convert." A 3-D reference references multiple sheets without specifying all of the corresponding sheet names. For example, in Lotus versions 3.x, the following formula adds cell A1 of sheets (plies) A, B, C, and D:
Sum(A:A1..D:A1)Microsoft Excel does not handle this type of reference; only the value of the formula will translate across.
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |