XL: Exporting Lotus 1-2-3 Linked Files to Excel
ID: Q122890
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 5.0, 5.0c
-
Microsoft Excel for Windows 95, version 7.0
-
Microsoft Excel 97 for Windows
SUMMARY
A 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 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:
- On the File menu, click Save As.
- 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:
- Open all dependent worksheets.
- Open the Lotus 1-2-3 source worksheet.
- With the Lotus 1-2-3 source worksheet active, choose Save As from the
File menu.
- Enter a name for the worksheet and select Microsoft Excel Workbook in
the Save File As Type box. Choose OK or press ENTER.
- 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:
- 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 Microsoft Excel workbook that you want to be the new source
workbook.
- Click OK.
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
Additional query words:
5.00c 97 XL97
Keywords : kbualink97 xlloadsave xl123Quattro
Version : WINDOWS:97,7.0,7.0a,5.0,5.0c
Platform : WINDOWS
Issue type :