XL98: Chart Disappears When You Open a Lotus WK4 File (178428)

SYMPTOMS

When you open a Lotus 1-2-3 WK4 file in Microsoft Excel 98 Macintosh Edition, all of the embedded charts in the file may disappear.

CAUSE

These problems occur if all of the following conditions are true:

Previously, you saved the file as a Microsoft Excel workbook. -and-
You then saved the file in the Lotus 1-2-3 WK4 file format. -and-
There are one or more embedded charts in a worksheet in the file. -and-
When you open the file, the worksheet that contains the chart is not the active worksheet.

For example, a file called Test contains an embedded chart in Sheet2, but Sheet1 is the active worksheet when you open the file. If Sheet1 contains an embedded chart or if Sheet2 is the active worksheet, the problem does not occur.

WORKAROUND

If this problem occurs in Microsoft Excel 98 Macintosh Edition, you can open the WK4 file. To work around the problem in which embedded charts disappear, open the WK4 file in Lotus 1-2-3, change the active worksheet to a worksheet that contains an embedded chart, and then resave the file.

NOTE: You may also recreate the charts. If you do this, make sure that the active worksheet contains an embedded chart if you resave the file in the WK4 file format.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.