This step-by-step article explains how to export Lotus 1-2-3 linked files to Microsoft Excel 2000.
A Lotus 1-2-3 worksheet that is opened in Microsoft Excel and containslinks to Lotus 1-2-3 source worksheets will maintain these links. Theselinks will still be maintained if the dependent worksheet is exported to aMicrosoft Excel workbook.
You can also export the Lotus 1-2-3 source worksheet to an Excelworkbook. The links to the 1-2-3 source document from a dependent worksheetwill automatically change to the newly converted Excelworkbook, provided that the dependent sheet is open when the source sheet isconverted to Microsoft Excel.
How to Export a Lotus 1-2-3 Dependent Worksheet to Excel
A Lotus 1-2-3 worksheet that is opened in Microsoft Excel will maintain anylinks that it has to Lotus 1-2-3 source worksheets. If this worksheet isexported to an Excel workbook, these links will be maintained.
Toexport the dependent worksheet, follow these steps:
In Lotus 1-2-3, from the File menu, choose Save As.
Type a name for the worksheet, click Microsoft Excel Workbook in the Save File As Type box, and then click OK or press ENTER.
How to Change Links in an Imported Dependent Document
If a dependent worksheet was not open when the source worksheet wasexported to an Excel workbook, its dependent links will stillpoint to the Lotus 1-2-3 worksheet. Links in the dependent sheet that stillpoint to a Lotus 1-2-3 source worksheet can be changed to point to an Excel workbook. To do so, follow these steps:
Close the Microsoft Excel workbook that is going to become the new source document.
Open the dependent document.
On the Edit menu, click Links.
Select the source file in which you want to change the link.
Click Change Source.
Select the Excel workbook that you want to be the new source workbook.
For more information about the Links command and redirecting links, click Microsoft Excel Help on the Help menu, type reconnect a linked object if the source file is moved or renamed in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.