Excel: References Change in File Transferred to Lotus 1-2-3Last reviewed: October 7, 1997Article ID: Q74821 |
2.20 3.00
MACINTOSH
kbother
SUMMARYWhen you transfer a file from Microsoft Excel for the Macintosh version 2.2 or 3.0 to Lotus 1-2-3, absolute column references are displaced by one column if cell A1 on the Excel spreadsheet is blank.
MORE INFORMATIONFor example, the following formulas from Excel
=$C1 =$C$1convert to Lotus 1-2-3 as
+$B1 +$B$1if cell A1 on the Excel spreadsheet is blank. To work around this problem, enter something in cell A1 before transferring the spreadsheet to Lotus. For a solution to this problem, contact Microsoft Product Support Services at (425) 635-7080.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |