Fix an Excel Combo Box Arrow That Does Nothing on Another Computer
Question details
The user needs to troubleshoot an Excel combo box that works on one computer but does not respond on another.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook containing a combo box is opened on a different computer.
- Observed behavior
- Clicking the combo box arrow does nothing on the other computer.
Confirm that you are opening the same workbook in the desktop version of Excel on both computers. If the Developer tab is hidden, enable it under File > Options > Customize Ribbon.
Check the combo box type and ActiveX settings
Use this method to determine whether ActiveX security settings are blocking the control.
On the working computer, open the Developer tab and select Design Mode, then right-click the combo box. An ActiveX control typically offers Properties; a Form Control offers Format Control.
On the affected computer, select Developer > Design Mode if it is active, then click the combo box arrow again. ActiveX controls do not run normally while Design Mode is on.
If the control is ActiveX, open File > Options > Trust Center > Trust Center Settings > ActiveX Settings. Review the available settings and allow the control only if you trust the workbook and your organization's policy permits it.
Close Excel, reopen the workbook, and click the combo box arrow. If a security warning appears, review it before enabling any content.

Compare Office versions and check the combo box configuration
Use these checks if the control still does not work or if it is a Form Control.
Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel files. It can help you migrate everyday spreadsheet work, but it does not fix Excel's ActiveX settings; test any controls and macros your workbook relies on.

Frequently Asked Questions
How can I tell whether my combo box is ActiveX or a Form Control?
Select Developer > Design Mode and right-click the combo box. An ActiveX control typically has a Properties option, while a Form Control has Format Control.
Why does the combo box work on one computer but not another?
The computers may have different Excel versions, updates, or ActiveX security settings. Compare File > Account > About Excel and check the affected computer's Trust Center settings.
What should I do if ActiveX settings are unavailable?
The settings may be managed by your organization. Contact your IT administrator and provide the workbook's source and the Excel version shown under File > Account > About Excel.
Will replacing the combo box preserve its macros?
Not necessarily. After adding a replacement through Developer > Insert, check its source range and any macro assignment or event code before relying on it.




