Lotus Charts Open Differently in Excel 4.0 and Later

ID: Q84865

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 5.0

SUMMARY

By default, Microsoft Excel automatically creates any charts associated with an imported Lotus worksheet when a 1-2-3 worksheet is opened.

Note that this behavior is different from earlier versions of Microsoft Excel.

If you do not want these charts to be created automatically, you can modify the Microsoft Excel initialization (.INI) file to disable this behavior.

MORE INFORMATION

Lotus 1-2-3 charts are part of a worksheet. Microsoft Excel uses a separate file for charts (unless they're embedded on the worksheet).

In Microsoft Excel version 2.1 or 3.0, when you open a Lotus 1-2-3 worksheet, you are prompted for permission to create any associated charts. In Microsoft Excel versions 4.0 and later, you are not prompted for permission.

To configure Microsoft Excel versions 4.0 and later so they ignore any associated charts when you open a Lotus 1-2-3 worksheet, you must modify the Microsoft .INI file.

To modify the Microsoft EXCEL4.INI or EXCEL5.INI file

In the EXCEL4.INI, [WK? Settings] section allows you to specify Lotus 1-2-3 worksheet settings.

If you want Microsoft Excel to automatically create all associated charts when a you open 1-2-3 worksheet is opened in Microsoft Excel, use the following setting:


   LOAD_CHART_WND=1

If you want Microsoft Excel to ignore associated charts, use this setting:


   LOAD_CHART_WND=0

For information on other Lotus 1-2-3 settings, see "Switching to Microsoft Excel from Lotus 1-2-3."

NOTE: To modify the .INI file, use a text editor such as Windows Notepad.

REFERENCES

In Microsoft Excel 5.0 for more information about using Microsoft Excel and Lotus 1-2-3 together, choose either of the following from the Help menu:

Lotus 1-2-3

-or-

Choose Search For Help On, and type:

Lotus 1-2-3, Graph

"User's Guide," version 5.0, pages 35-37, 724
"Switching to Microsoft Excel from Lotus 1-2-3," version 4.0, page 38

Additional query words: 4.0 graph 123

Keywords :
Version :
Platform :
Issue type :