Office Installation Errors

Install or Replace the Date Picker ActiveX Control in Excel 365

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

The user wants to find installation guidance for the legacy Date and Time Picker ActiveX control in Excel for Microsoft 365.

Install or Replace the Date Picker ActiveX Control in Excel 365
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
Adding a date picker to a worksheet when the control is missing from the Additional Controls list.
Observed behavior
The Microsoft Date and Time Picker control does not appear under Additional Controls.
Before you start

In desktop Excel for Windows, select File > Account > About Excel to check whether your installation is 32-bit or 64-bit. The legacy Date and Time Picker control is not compatible with 64-bit Excel.

Solution 1Recommended

Use a Calendar Add-in Instead of the Legacy ActiveX Control

Use an add-in when you need a calendar interface and the legacy control is unavailable or incompatible.

1
Open the add-in store

In Excel, select Insert > Get Add-ins. The button may be labeled Office Add-ins in some versions.

2
Find a date picker

Search the store for date picker or calendar, then review an add-in's compatibility, permissions, and instructions.

3
Add and use the picker

Select Add for a suitable add-in, then follow its instructions to enter dates into worksheet cells.

Use a Calendar Add-in Instead of the Legacy ActiveX Control
Availability varies: Available add-ins depend on your Excel version, region, and organization settings. An add-in does not install the legacy ActiveX control.
Free Microsoft Office alternative

Work With Date-Based Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open existing Excel files and continue editing your worksheets without installing the legacy Excel ActiveX control. WPS Office does not fix or replace that control in Microsoft Excel.

Edit date-based worksheets in WPS SpreadsheetsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier move from Microsoft OfficeWork with a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why is the Date and Time Picker missing from Additional Controls?

The legacy control may not be installed or registered, and it is not compatible with 64-bit Excel. Check your Excel version under File > Account > About Excel.

Can I install the legacy date picker in 64-bit Excel 365?

No. The legacy Date and Time Picker ActiveX control is not compatible with 64-bit Excel. Consider a calendar add-in or a custom VBA form instead.

How do I find a calendar add-in in Excel?

Select Insert > Get Add-ins and search for date picker or calendar. Check the add-in's compatibility and instructions before selecting Add.

Does Excel date validation display a calendar?

No. Data > Data Validation can restrict entries to a date range, but it does not provide a calendar popup.

Where is the Developer tab in Excel?

In desktop Excel for Windows, select File > Options > Customize Ribbon, check Developer, and select OK.