XL: Exporting Lotus 1-2-3 Linked Files to ExcelLast reviewed: June 3, 1997Article ID: Q122890 |
5.00 5.00c 7.00 97
WINDOWS
kb3rdparty kbother
The information in this article applies to:
SUMMARYA Lotus 1-2-3 worksheet that is opened in Microsoft Excel and contains links to Lotus 1-2-3 source worksheets will maintain these links. These links will still be maintained if the dependent worksheet is exported to a Microsoft Excel workbook. You can also export the Lotus 1-2-3 source worksheet to a Microsoft Excel workbook. The links to the 1-2-3 source document from a dependent worksheet will automatically change over to the newly converted Microsoft Excel workbook provided that the dependent sheet is open when the source sheet is converted to Microsoft Excel.
MORE INFORMATION
To export a dependent Lotus 1-2-3 worksheet to Microsoft ExcelA Lotus 1-2-3 worksheet that is opened in Microsoft Excel will maintain any links it has to Lotus 1-2-3 source worksheets. If this worksheet is exported to a Microsoft Excel workbook these links will be maintained. To export the dependent worksheet use the following steps:
To export a Lotus 1-2-3 source worksheet to Microsoft ExcelTo export a Lotus 1-2-3 source worksheet to a Microsoft Excel workbook and have all dependent Microsoft Excel workbooks automatically change dependent links to the new Microsoft Excel workbooks, use the following steps:
REFERENCES"User's Guide," version 5.0, Chapter 3, "Linking Documents from Other Spreadsheets with Microsoft Excel Workbooks" "User's Guide," version 5.0, Chapter 10, "Working with Links" For more information about the Links command (Edit menu) and redirecting links, choose the Search button in Help and type:
Redirecting links to source documents |
KBCategory: kb3rdparty kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |