Fix an ActiveX Control That Will Not Register in Excel 365
Question details
The user needs to make a custom OCX ActiveX control available in Excel 365.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- A custom ActiveX control works in an older Office version but is missing from the Excel 365 ActiveX list.
- Observed behavior
- Registering the OCX displays an error that the file contains no self-registering ActiveX controls.
Check whether your Office installation is 32-bit or 64-bit in Excel by selecting File > Account > About Excel. Confirm the OCX control's supported architecture and keep an administrator account available before registering it.
Match the OCX control architecture to your Office installation
Use this solution when a legacy ActiveX control works in older Office versions but is unavailable in 64-bit Excel 365.
Many older OCX controls were built only for 32-bit Office. A 32-bit control generally cannot be loaded by 64-bit Excel, even when the file is present and registration is attempted.
Open Excel and select File > Account > About Excel. Note whether the installation is 32-bit or 64-bit.
Check the control vendor's documentation or installation package to determine whether the OCX supports 32-bit or 64-bit Office.
If the OCX supports only 32-bit Office, uninstall the incompatible Office installation and install the 32-bit version of Microsoft 365 or Office using the Microsoft account or deployment tool.
Restart Excel, open the Developer tab, select Insert, and check the ActiveX Controls section for the custom control.
Register the OCX with the matching system tool
Use this solution when the control architecture matches Office but registration still fails or the control does not appear in Excel.
Use WPS Office as a Lightweight Alternative for Excel Workbooks
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong Microsoft Excel format compatibility. It can help you open, edit, and migrate standard workbooks when a legacy ActiveX control is not essential, although it does not repair Microsoft Excel ActiveX registration or guarantee support for custom OCX controls.
- 1. Install WPS Office: Download and install WPS Office, then launch WPS Spreadsheets from the Start menu or applications list.
- 2. Open the workbook: Select Menu > Open, choose the Excel XLS or XLSX workbook, and review its contents in WPS Spreadsheets.
- 3. Check workbook functionality: Test formulas, charts, and standard spreadsheet features; custom ActiveX controls and Excel-specific components may not work.
- 4. Save a compatible copy: Select Menu > Save As and choose Excel 2007-365 Workbook (*.xlsx) when you need to share the edited file with Microsoft Excel users.
Frequently Asked Questions
Why does my OCX control work in older Office but not Excel 365?
The older Office installation may be 32-bit while Excel 365 is 64-bit. Many legacy ActiveX controls are built only for 32-bit Office and cannot load in 64-bit Excel.
Which Regsvr32 tool should I use for a 32-bit ActiveX control?
On 64-bit Windows, use %windir%\SysWOW64\regsvr32.exe for a 32-bit OCX. Use %windir%\System32\regsvr32.exe for a 64-bit OCX, and run Command Prompt as administrator.
What does the message about no self-registering ActiveX controls mean?
It usually means the OCX is not self-registering, the wrong Regsvr32 tool was used, the file is incompatible with the system architecture, or the control requires a vendor-provided installer.
How can I check whether Excel is 32-bit or 64-bit?
Open Excel, select File > Account, and choose About Excel. The dialog identifies the installed Office architecture.
Can WPS Office register or repair a custom Excel ActiveX control?
No. ActiveX registration is an Excel and Windows compatibility issue. WPS Office can open and edit many XLS and XLSX files, but it does not repair custom OCX registration or guarantee support for ActiveX controls.
