File Format & Compatibility

Remove ActiveX and Form Controls from an Excel Online Workbook

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user needs to remove controls that interfere with viewing or editing an Excel workbook in a browser.

Remove ActiveX and Form Controls from an Excel Online Workbook
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.
Before you start

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.

Solution 1Recommended

Delete unwanted controls in desktop Excel

Use desktop Excel to remove worksheet controls that are causing browser compatibility issues.

1
Open the workbook

Open the workbook in desktop Excel and go to the worksheet containing the controls.

2
Show the Developer tab

If Developer is not visible in Excel for Windows, select File > Options > Customize Ribbon, check Developer, and select OK.

3
Enable Design Mode

On the Developer tab, select Design Mode so you can select controls instead of activating them.

4
Select and delete controls

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.

5
Save and test

Select File > Save, then reopen the workbook in Excel for the web and check whether the compatibility report is resolved.

Delete unwanted controls in desktop Excel
Macros are separate: Deleting controls does not remove their VBA macros. Macros cannot run in Excel for the web, and other unsupported workbook features may still cause compatibility warnings.
Free Microsoft Office alternative

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.

Open and edit Excel-compatible XLSX spreadsheetsUse familiar spreadsheet tools for everyday workbook editingWork with files in a lightweight, easy-to-use office suiteMove existing spreadsheets to WPS without changing your usual file format
microsoft office alternative - wps office

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.