XL97: Error Inserting ActiveX Object in a Worksheet

This article was previously published under Q165450
This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
When you insert an ActiveX control onto a Microsoft Excel worksheet, youmay receive the following error message:
Cannot insert object
Cause
You receive this error message if the ActiveX control that you areinserting does not support the IDataObject OLE interface.
Status
This behavior is by design of Microsoft Excel 97.
More information
You can insert an ActiveX control onto a Microsoft Excel worksheet usingthe Control Toolbox toolbar. By default, only the controls in the Fm20.dllfile that ships with Microsoft Office are available on the Control Toolboxtoolbar. Clicking More Controls on the Control Toolbox toolbar displays alist of other ActiveX controls that are registered on your computer.

The following ActiveX controls are installed with Microsoft Excel 97. Thesecontrols are the only ActiveX controls that are fully tested and supportedfor use with Microsoft Excel.
 ActiveX Control Name          Installed with                          File Name ----------------------------------------------------------------------- Check Box             Microsoft Office 97                     Fm20.dll Text Box              Microsoft Office 97                     Fm20.dll Command Button        Microsoft Office 97                     Fm20.dll Option Button         Microsoft Office 97                     Fm20.dll List Box              Microsoft Office 97                     Fm20.dll Combo Box             Microsoft Office 97                     Fm20.dll Toggle Button         Microsoft Office 97                     Fm20.dll Spin Button           Microsoft Office 97                     Fm20.dll Scroll Bar            Microsoft Office 97                     Fm20.dll Label                 Microsoft Office 97                     Fm20.dll Image                 Microsoft Office 97                     Fm20.dll				
You can insert the following ActiveX controls onto a Microsoft Excelworksheet without receiving an error message. However, these ActiveXcontrols have not been tested for use on Microsoft Excel worksheets. Thesecontrols may not be fully functional.
 ActiveX Control Name          Installed with                          File Name -------------------------------------------------------------------------- Calendar Control     Microsoft Office 97                     Mscal.ocx Web Browser Control  Microsoft Office 97 ValuPack            Shdocvw.dll MsComm Control       Microsoft Visual Basic 5.0 Professional Mscomm32.ocx MAPIMessages Control Microsoft Visual Basic 5.0 Professional Msmapi32.ocx MAPISessions Control Microsoft Visual Basic 5.0 Professional Msmapi32.ocx Masked Edit Control  Microsoft Visual Basic 5.0 Professional Msmask32.ocx Picture Clip Control Microsoft Visual Basic 5.0 Professional Piclclp32.ocx
NOTE: Other ActiveX controls that exhibit the behavior discussed in thisarticle may be installed on your computer. These controls are not listed inthe table.

When you insert the following ActiveX controls on a Microsoft Excelworksheet, you receive the error message in this article.
 ActiveX Control Name        Installed with                           File Name ------------------------------------------------------------------------- Animation Control   Microsoft Office 97, Developer Edition   Comct232.ocx                     Microsoft Visual Basic 5.0 Professional Common Dialog Control             Microsoft Office 97, Developer Edition   Comdlg32.ocx ImageList Control   Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional ListView Control    Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional Rich Textbox Control             Microsoft Office 97, Developer Edition   Richtx32.ocx MSInet Control      Microsoft Office 97, Developer Edition   Comctl32.ocx ProgressBar Control Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional Slider Control      Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional StatusBar Control   Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional TabStrip Control    Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional Toolbar Control     Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional TreeView Control    Microsoft Office 97, Developer Edition   Comctl32.ocx                     Microsoft Visual Basic 5.0 Professional UpDown Control      Microsoft Office 97, Developer Edition   Comct232.ocx                     Microsoft Visual Basic 5.0 Professional WinSock Control     Microsoft Office 97, Developer Edition   Mswinsck.ocx                     Microsoft Visual Basic 5.0 Professional Internet Transfer   Microsoft Visual Basic 5.0 Professional  Msinet.ocx FlexGrid Control             Microsoft Visual Basic 5.0 Professional Msflexgrid.ocx RichText Control    Microsoft Visual Basic 5.0 Professional  Richtx32.ocx Tabbed Dialog Control             Microsoft Visual Basic 5.0 Professional  Tabctl32.ocx DBList Control      Microsoft Visual Basic 5.0 Professional  Dblist32.ocx DBGrid Control      Microsoft Visual Basic 5.0 Professional  Dbgrid32.ocx				
NOTE: Other ActiveX controls that exhibit the behavior discussed in thisarticle may be installed on your computer. These controls are not listed inthe table.
References
For more information about inserting ActiveX controls, click the Index tabin Microsoft Excel Help, type the following text
activex controls, adding
and then double-click the selected text to go to the "Add buttons, checkboxes, or other controls to a worksheet" topic.
XL97 ocx ole active x
Properties

Article ID: 165450 - Last Review: 10/26/2013 04:45:00 - Revision: 2.0

  • Microsoft Excel 97 Standard Edition
  • kbnosurvey kbarchive kberrmsg kbinterop kbprb KB165450
Feedback