XL: Unable to Import a Quattro Pro or Symphony File

ID: Q86295

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2, versions 2.2, 3.0

SYMPTOMS

In Microsoft Excel, you cannot directly import the following spreadsheets:


   If you are using Microsoft Excel 5.0 for Windows
   ------------------------------------------------

    - A Symphony file if it is in the .WR1 file format.

   If you are using Microsoft Excel 4.x
   or Microsoft Excel 5.0 for the Macintosh
   ----------------------------------------

    - A Symphony file if it is in the .WR1 file format.
    - A Quattro Pro spreadsheet if it is in the .WQ1 file format

WORKAROUND

To open a .WR1 or .WQ1 file in Microsoft Excel, first open it in Lotus 1-2-3, save it in a Lotus 1-2-3 file format, and then open it in Microsoft Excel.

NOTE: You cannot open .WB1 files in Microsoft Excel version 5.0.

Saving the file in Lotus 1-2-3

To save a Quattro Pro file in a Lotus 1-2-3 file format, follow these steps:

In Quattro Pro, open the file you want to open in Microsoft Excel.

On the File menu, click Save As.

Type the name of the file and use either the .WK3, .WK1, or .WKS file name extension. (You can also save the file in the .SLK or .DBF format).

Note that saving a Quattro Pro for Windows file in the .WK3 file format seems to retain more of the advanced settings. The .WK1 and .WKS formats may not retain the sheet settings and functions.

To save a Lotus Symphony file in the .WK3, .WK1, or .WKS file format, follow these steps:

In Lotus 1-2-3, open the file you want to open in Microsoft Excel.

Press the F9 key to recalculate the worksheet.

Click File Save.

Type the full path of the directory in which you want to save the file followed by the file name and the .WK3, .WK1, or .WKS file name extension.

Opening the .WK3, .WK1, or .WKS File in Microsoft Excel

To open the newly saved file in Microsoft Excel, follow these steps:

On the File menu, click Open.

Switch to the directory that contains the file you want to open.

In the File Name box, type *.wk*, or click Lotus 1-2-3 in the List Files Of Type box to locate the file.

Select the file in the File Name box and click OK.

For additional information, please see the following articles in the Microsoft Knowledge Base:

Q111981 : XL5: Functions Not Saved to Quattro Pro File Format

Q110708 : XL5: Formatting and Charts Not Saved to .WQ1 Format

REFERENCES

"User's Guide," version 5.0, pages 31, 724

"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 User's Guide," version 3.0, pages 253-256

Quattro Pro Help, "Retrieving and Saving 1-2-3 Files"

Additional query words: 1.0 1.00 1.03 1.04 1.5 1.50 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.00a 5.0 Borland worksheets export translate 123


Keywords          : kb3rdparty xl123Quattro 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 26, 1999