XL: Objects in Quattro Pro .WB1 Files Do Not Convert

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

SYMPTOMS

Microsoft Excel for Windows 95, version 7.0 and Microsoft Excel 97 for Windows, contain a filter to open Quattro Pro for Windows, version 5.0 (WB1), files. However, objects such as drawing objects, OLE objects, and most commonly, Chart objects, contained in the .WB1 file fail to be converted and will not display.

NOTE: Files created in Quattro Pro for Windows, version 6.0, and saved in the .WB1 format (instead of the Quattro Pro 6.0 file format of .WB2) behave the same way.

CAUSE

This problem occurs because the filter for .WB1 files does not support the conversion of any objects. This behavior is by design of Microsoft Excel.

RESOLUTION

You can convert the objects contained in .WB1 files by saving the file as a different file type. To do this, use the following steps:

1. Open the .WB1 files in Quattro Pro for Windows (version 5.0).

2. On the File menu, click Save As.

3. In the list of File Types, click either 1-2-3 v3.x (*.WK3) or QP/DOS (*.WQ1).

4. Change the file name and its location, if needed. Click OK.

5. Open the file (*.WK3 or *.WQ1) in Microsoft Excel.

MORE INFORMATION

The file filter for Quattro Pro for Windows files (.WB1) opens the files read-only. The files open read-only because the filter allows Microsoft Excel to read the file format, but does not allow Microsoft Excel to save in that format (.WB1).

REFERENCES

For more information about File Converters, click the Index tab in Microsoft Excel Help and type:

   converting documents