Exporting Lotus 1-2-3 Linked Files to Excel (122890)

MORE INFORMATION

To Export a Dependent Lotus 1-2-3 Worksheet to Microsoft Excel

A 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:

1. On the File menu, click Save As.
2. Enter a name for the worksheet and select Microsoft Excel Workbook in the Save File As Type box. Click OK or press ENTER.

To Export a Lotus 1-2-3 Source Worksheet to Microsoft Excel

To 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:

1. Open all dependent worksheets.
2. Open the Lotus 1-2-3 source worksheet.
3. With the Lotus 1-2-3 source worksheet active, choose Save As from the File menu.
4. Enter a name for the worksheet and select Microsoft Excel Workbook in the Save File As Type box. Choose OK or press ENTER.
5. Save all of the dependent worksheets.

If a dependent worksheet was not open when the source worksheet was exported to a Microsoft Excel workbook, its dependent links will still point to the Lotus 1-2-3 worksheet. Links in the dependent sheet that still point to a Lotus 1-2-3 source worksheet can be changed to point to a Microsoft Excel 5.0 workbook by using the following steps:

1. Close the Microsoft Excel workbook that is going to become the new source document.
2. Open the dependent document.
3. On the Edit menu, click Links.
4. Select the source file in which you want to change the link.
5. Click Change Source.
6. Select the Microsoft Excel workbook that you want to be the new source workbook.
7. Click OK.