Remove ActiveX and Form Controls from an Excel Online Workbook
Question details
The user needs to remove controls that interfere with viewing or editing an Excel workbook in a browser.

- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- A workbook containing ActiveX controls, form controls, toolbox controls, or macros is opened in Excel for the web.
- Observed behavior
- Excel for the web may show a compatibility report or be unable to display the workbook fully.
Make sure you can open the workbook in desktop Excel; use Excel for Windows if you need to work with ActiveX controls. Identify which controls are no longer needed, because deleting them removes their associated functionality.
Delete unwanted controls in desktop Excel
Use desktop Excel to remove worksheet controls that are causing browser compatibility issues.
Open the workbook in desktop Excel and go to the worksheet containing the controls.
If Developer is not visible in Excel for Windows, select File > Options > Customize Ribbon, check Developer, and select OK.
On the Developer tab, select Design Mode so you can select controls instead of activating them.
Click each unwanted control on the worksheet and press Delete. For a form control, you can also right-click its border to select it before pressing Delete.
Select File > Save, then reopen the workbook in Excel for the web and check whether the compatibility report is resolved.

Find hard-to-select worksheet objects
Use Excel's object selection tools when an unwanted control is difficult to locate or select.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move everyday workbook editing to WPS. It does not fix Excel for the web compatibility reports, and control or macro support may differ.

Frequently Asked Questions
Can I delete ActiveX controls in Excel for the web?
Use desktop Excel for Windows to remove ActiveX controls. Open the workbook, select Developer > Design Mode, select the unwanted controls, and press Delete.
What if I cannot see the Developer tab?
In Excel for Windows, select File > Options > Customize Ribbon, check Developer, and select OK.
Will deleting a control also remove its macro?
No. A control and its associated VBA code are separate. Removing the control does not delete the macro, and macros cannot run in Excel for the web.
Why does the compatibility report still appear after I delete a control?
The workbook may contain other unsupported controls or features. Reopen it in desktop Excel, check the affected worksheets for remaining objects, and review the compatibility report again after saving.




