Office Compatibility Issues

Fix a Missing Date Picker in Excel 365 More Controls

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

The user needs to make a Date Picker available in Excel 365 or find a compatible alternative.

Fix a Missing Date Picker in Excel 365 More Controls
Product
Microsoft Excel 365
Device & OS
not provided
Scenario
The user wants to insert a Date Picker from Developer > Insert > More Controls after installing and registering the control.
Observed behavior
The Date Picker does not appear in the More Controls list.
Before you start

In desktop Excel, open File > Account > About Excel and check whether the installed version is 32-bit or 64-bit. The legacy Date Picker is an ActiveX control for Windows; a 32-bit Excel installation alone does not guarantee that the control is installed or available.

Solution 1Recommended

Check the legacy Date Picker in 32-bit Excel

Use this check if you have 32-bit Excel and the Date Picker is still missing from More Controls.

1
Confirm the Excel architecture

Open File > Account > About Excel and look for 32-bit or 64-bit in the version information. The legacy Microsoft Date Picker is not compatible with 64-bit Excel.

2
Check the controls list

In Excel for Windows, open Developer > Insert > More Controls and look for Microsoft Date and Time Picker Control. If the Developer tab is hidden, enable it under File > Options > Customize Ribbon.

3
Verify the control installation

If you use 32-bit Excel and the control is absent, ask your IT administrator to verify that a legitimate 32-bit version of the control is installed and correctly registered for your environment. Do not download an OCX file from an untrusted site.

4
Review ActiveX restrictions

Check File > Options > Trust Center > Trust Center Settings > ActiveX Settings, if available, or ask your administrator whether organizational policy restricts ActiveX. Do not change security settings unless your administrator approves.

Check the legacy Date Picker in 32-bit Excel
Availability varies: The legacy control is not guaranteed to be included with Excel 365, even in the 32-bit edition. If it remains unavailable, use a compatible Date Picker alternative.
Free Microsoft Office alternative

Enter and format dates in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface for opening spreadsheets and entering dates. It supports common Excel formats for easier migration, but it does not fix Excel's missing ActiveX control.

Enter dates in spreadsheet cells and apply date formatsCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Date Picker missing from 64-bit Excel?

The legacy Microsoft Date Picker is a 32-bit ActiveX control and is not compatible with 64-bit Excel. Check File > Account > About Excel, then consider a Date Picker add-in that supports your version.

Why is the Date Picker missing even though I use 32-bit Excel?

The control may not be installed or registered, or its use may be restricted. Check Developer > Insert > More Controls and ask your administrator to verify the installation and ActiveX policy.

Will a Date Picker add-in appear in More Controls?

Not necessarily. An add-in may open its calendar from its own ribbon tab or button instead of registering an ActiveX control in More Controls. Follow the publisher's instructions.

Can WPS Office restore the missing Excel ActiveX control?

No. WPS Office is an alternative spreadsheet suite, not a repair for Excel's ActiveX controls. You can use WPS Spreadsheet to enter and format dates in compatible XLS and XLSX files.