The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you open a file that contains an external link to a Lotus 1-2-3 file (.WK3 or .WK4), the link value displayed in the destination cell may be incorrect. CAUSE
This behavior occurs when the linked (Lotus 1-2-3) file is closed if the
link references a worksheet in the Lotus 1-2-3 file beyond the 26th
worksheet (beyond sheet Z by default). When this occurs, the destination
cell displays the value contained in the same cell reference on another
worksheet in the file; the worksheet with the number of the linked
worksheet number minus 26. For example, when you open a file in Microsoft
Excel that contains an external link to cell A1 on sheet AA (the 27th
worksheet in the .WK3 or .WK4 file), the value displayed in the linked cell
is the value contained in cell A1 on sheet A (the first worksheet in the
.WK3 or WK4 file).
WORKAROUND
To work around this problem, you can open the source file (the Lotus 1-2-3
WK3 or WK4 file that contains the linked information) in Microsoft Excel
also, so that both the source and destination files are open in Microsoft
Excel.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0. MORE INFORMATION
Note that to open a Lotus 1-2-3 WK4 file in Microsoft Excel 5.x, you must
obtain the Lotus 1-2-3 WK4 file converter.
Q122583 XL5: AppNote: Lotus 1-2-3 WK4 File Converter (WE1130)The Lotus 1-2-3 products included here are manufactured by Lotus Development, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability. REFERENCES
For more information about "Linking Lotus 1-2-3 Worksheets And Microsoft
Excel Worksheets," choose the Search button in Help and type:
Additional query words: 5.00c wrong
Keywords : xlwin |
Last Reviewed: July 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |