XL5: Graphs Not Saved to Lotus .WK3 (1-2-3) File Format

 Last reviewed: September 12, 1996
Article ID: Q112460
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, if you save a file that contains graphs to the Lotus .WK3 (1-2-3) file format, the graphs are gone when you reopen the file.

NOTE: This problem also occurs if you save the file to the WK3,FM3 (1-2-3) file format.

WORKAROUND

In Microsoft Excel, to save a Lotus 1-2-3 file that contains graphs without losing the graphs, do either of the following:

  • Activate each graph by selecting each chart sheet tab before you save the file. Each chart sheet that has been activated is saved when you save the file to the .WK3 (1-2-3) file format.

    -or-

  • Save the file in Microsoft Excel file format.

MORE INFORMATION

When you open a Lotus 1-2-3 file that contains graphs in Microsoft Excel, each graph is opened as a separate chart sheet.

For more information on graph options in Lotus 1-2-3 and the equivalent commands in Microsoft Excel, choose Lotus 1-2-3 from the Help menu. data. from 3)

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.