Transferring Files Between Macintosh Excel and Lotus 1-2-3

Last reviewed: November 30, 1994
Article ID: Q35710
The information in this article applies to:
  • Microsoft Excel for Windows versions 2.x, 3.0 and 4.0
  • Microsoft Excel for OS/2 versions 2.2 and 3.0
  • Microsoft Excel for the Macintosh versions 2.x, 3.0 and 4.0

Because of the differences in disk formats between the PC (IBM-compatible) and Macintosh, there is no way to use a Macintosh formatted disk in an IBM or IBM-compatible computer. However, there are devices on the market that are designed to aid you in transferring files. A Daynafile is an example of an MS-DOS formatted disk drive that you can plug into your Macintosh. This allows you to copy information directly from a Macintosh onto an MS-DOS formatted disk. This disk can then be used in an IBM-compatible computer.

File transferring can also be accomplished using Macintosh and PC communication programs. This is done through modems connected to each machine. To maintain file integrity, the file should be sent using an error-correcting protocol such as XMODEM or YMODEM.

The third method of transferring files is through the Tops network, which must be installed on both the Macintosh and PC computers. This method of file transferring allows you to simulate a Macintosh disk on the PC or a PC disk on the Macintosh.

Once a method of transferring files has been found, you must do the following:

  1. Save the file from Microsoft Excel for the Macintosh by choosing Save As from the File menu and selecting the WK1 format option (use WKS if you are using an version of Lotus 1-2-3 prior to 2.0).

  2. Transfer these files using one of the methods discussed earlier. These files should then open into Lotus 1-2-3 as if they were saved normally from Lotus 1-2-3.


KBCategory: kbusage
KBSubcategory:

Additional words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21
3.03.00 4.0 4.00


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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.