Fix Excel Combo Boxes Disappearing on Mac Due to ActiveX Incompatibility
Question details
Users experience Excel combo boxes and other interactive controls disappearing or failing to display when opening a Windows-created workbook on a Mac.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Opening a shared Excel workbook containing interactive combo boxes or buttons on a Mac device.
- Observed behavior
- Combo boxes and other interactive controls are completely invisible or non-functional because Excel for Mac does not support the ActiveX controls used to build them.
Verify whether the missing controls in your Excel workbook were originally created using ActiveX Controls or standard Form Controls on a Windows PC.
Replace ActiveX Controls with Form Controls
Form Controls are natively supported on both Windows and macOS, making them the ideal replacement for Windows-exclusive ActiveX controls.
ActiveX controls rely entirely on the Windows operating system architecture and cannot run on macOS. To make your workbooks cross-platform, you must recreate the interactive elements using standard Form Controls.
Open the affected workbook in Excel for Windows, where the ActiveX controls are still visible and fully functional.
Navigate to the Developer tab on the top ribbon. Click on the 'Insert' icon located in the Controls group.
Under the 'Form Controls' section (do not choose ActiveX Controls), select the 'Combo Box' icon and draw it onto your spreadsheet.
Right-click the newly created Combo Box, select 'Format Control', and set up your Input Range and Cell Link to match the settings of your old ActiveX control.
Delete the unsupported ActiveX controls from the sheet, save the workbook, and test opening the file on your Mac.

Update Excel for Mac and Verify in a New File
Ensure your Office suite is fully updated to avoid rendering bugs that occasionally affect cross-platform files.
Use WPS Office for Seamless Cross-Platform Spreadsheets
Avoid compatibility headaches like unsupported ActiveX errors. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office that works smoothly across Windows, macOS, and Linux, ensuring your spreadsheet data and formatting display perfectly everywhere.

Frequently Asked Questions
Why do ActiveX controls only work on Windows?
ActiveX is a software framework created specifically for the Windows OS ecosystem. Because it relies on deep system-level integrations unique to Windows, it cannot be executed or rendered on macOS, Linux, or mobile operating systems.
What is the difference between Form Controls and ActiveX Controls in Excel?
Form Controls are built directly into Excel and function uniformly across both Windows and Mac environments. ActiveX controls offer more extensive customization and event-handling capabilities but are strictly limited to Windows.
How can I tell if my workbook uses ActiveX controls?
If you open the workbook on a Windows PC, go to the Developer tab, and click 'Design Mode'. If clicking on the combo box allows you to view its properties as an ActiveX object (e.g., named 'ComboBox1'), it is an ActiveX control.
Can I use VBA macros in Excel for Mac?
Yes, Excel for Mac supports VBA macros. However, if your VBA code references Windows-specific objects, specific dynamic-link libraries (DLLs), or interacts directly with ActiveX controls, the macro will generate an error when run on macOS.




