XL: Exporting Lotus 1-2-3 Linked Files to Excel

Last reviewed: June 3, 1997
Article ID: Q122890
5.00 5.00c 7.00 97 WINDOWS kb3rdparty kbother

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:

  1. From the File menu, choose Save As.

  2. Enter a name for the worksheet and select Microsoft Excel Workbook in the Save File As Type box. Choose 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. From the Edit menu, choose Links.

  4. Select the source file in which you want to change the link.

  5. Choose the Change Source button.

  6. Select the Microsoft Excel workbook that you want to be the new source workbook.

  7. Choose 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


KBCategory: kb3rdparty kbother
KBSubcategory: xl123Quattro xlloadsave
Additional reference words: 5.00 5.00c 7.00 97 XL97

Keywords : kbualink97 xl123Quattro xlloadsave kb3rdparty kbother
Version : 5.00 5.00c 7.00 97
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.