Fix a Missing Date Picker in Excel 365 More Controls
Question details
The user needs to make a Date Picker available in Excel 365 or find a compatible alternative.

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

Use a compatible Date Picker add-in
Use an add-in if you have 64-bit Excel or cannot obtain the legacy control in 32-bit Excel.
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.

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.




