XL: Unable to Import a Quattro Pro or Symphony File

• 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:

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

2. On the File menu, click Save As.

3. 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).

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

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

2. Press the F9 key to recalculate the worksheet.

3. Click File Save.

4. 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:

1. On the File menu, click Open.

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

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

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

   ARTICLE-ID: Q111981
   TITLE     : XL5: Functions Not Saved to Quattro Pro File Format

   ARTICLE-ID: Q110708
   TITLE     : 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"