Microsoft KB Archive/104237

From BetaArchive Wiki

Excel: Importing a Quattro Pro or Symphony File PSS ID Number: Q104237 Article last modified on 10-26-1993 PSS database name: W_eXceL

2.X 3.00 4.00 4.00a | 2.20 2.21 3.00 | 2.X 3.00 4.00


The information in this article applies to:
- Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, and 4.0a - Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, and 4.0 - Microsoft Excel for OS/2, versions 2.2 and 3.0


In Microsoft Excel, you cannot directly import a Quattro Pro spreadsheet if it is in the .WQ1 file format or a Symphony file if it is in the .WR1 file format.

To open these files in Microsoft Excel, you must first save them in in Lotus 1-2-3 .WK1 or .WKS file format.


Saving Your File

To save a Quattro Pro file in the .WK1 or .WKS file format:

  1. In Quattro Pro, open the file you want to be able to open in Microsoft Excel.
  2. From the File menu, choose Save As.
  3. Type the name of your file and use either the .WK1 or .WKS filename extension (you can also save the file in the .SLK or .DBF format).

To save a Lotus Symphony file in the .WK1 or .WKS file format:

  1. In Lotus 1-2-3, open the file you want to be able to open in Microsoft Excel.
  2. Press the F9 key to recalculate the worksheet.
  3. Choose File Save.
  4. Type the full pathname of the directory you want to save to followed by the filename and the .WK1 or .WKS filename extension.

Opening the .WK1 or .WKS File in Microsoft Excel

To open the newly saved file in Microsoft Excel:

  1. From the File menu, choose Open.
  2. Change to the directory containing the file you want to open.
  3. In the File Name box, type “.wk” (without the quotation marks), or choose Lotus 1-2-3 from the List Files Of Type Box, to locate your file.
  4. Select the file from the File Name box and choose the OK button.


“User’s Guide 2,” version 4.0, pages 147-152 “User’s Guide,” version 3.0, pages 56-61 “Function Reference Guide,” version 2.10, pages 484-485 “Quattro Pro Users Guide,” version 3.0, pages 253-256 Quattro Pro Help, “Retrieving and Saving 1-2-3 Files”

Additional reference words: 2.x 3.00 4.00 4.00a mpf Borland worksheets export translate 123

Copyright Microsoft Corporation 1993.