Office Compatibility Issues

Fix an Excel Combo Box Arrow That Does Nothing on Another Computer

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

Question details

The user needs to troubleshoot an Excel combo box that works on one computer but does not respond on another.

Fix an Excel Combo Box Arrow That Does Nothing on Another Computer
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.
Before you start

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.

Solution 1Recommended

Check the combo box type and ActiveX settings

Use this method to determine whether ActiveX security settings are blocking the control.

1
Identify 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.

2
Turn off Design Mode

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.

3
Review ActiveX settings

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.

4
Restart and test

Close Excel, reopen the workbook, and click the combo box arrow. If a security warning appears, review it before enabling any content.

Check the combo box type and ActiveX settings
ActiveX security: ActiveX controls may be disabled by default or managed by your organization. If the setting is unavailable, contact your IT administrator rather than bypassing the policy.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workMove existing spreadsheets into a lightweight office suiteReview workbook data and formulas when a combo box is not essential
QA img-9

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.