About linking Lotus 1-2-3 and Microsoft Excel worksheets

Benefits of links     Linking lets you use your Lotus 1-2-3 data in a Microsoft Excel worksheet without converting to Excel workbook format. Then when you change the data in the Lotus 1-2-3 worksheet, the Excel worksheet is automatically updated.

For example, you can link cells containing sales figures from various Lotus 1-2-3 worksheets to cells in a single Excel worksheet. Then you can create a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) to summarize the data, create a chart to emphasize the summary values, or use the format and print features of Excel to create a summary report of sales.

Types of files you can link to     You can link cells in Excel worksheets to cells in files saved in any of the following Lotus 1-2-3 formats: WKS, WK1, WK3, and WK4. If you use Lotus 1-2-3 to edit a Lotus 1-2-3 worksheet that is linked to an Excel worksheet, the linked cells will update when you open the Excel workbook.

Finding the source file for a link     If you are unsure of the name or location of a Lotus 1-2-3 worksheet that provides data to an Excel worksheet, you can open the Excel workbook and then use the Links command (Edit menu) to open the Lotus 1-2-3 worksheet.

Changing or redirecting links     You can also use the Links command to change or redirect the links in the Excel worksheet to refer to another worksheet.

 
 
Applies to:
Excel 2003