'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Date Picker Missing in 64-Bit Excel on Windows 11
Question details
The user is unable to find the Microsoft Date and Time Picker Control 6.0 in ActiveX controls, and cannot access the Office Store to download an alternative add-in.
- Product
- Microsoft Excel
- Device & OS
- Windows 11
- Scenario
- Attempting to insert a calendar or date picker control into an Excel spreadsheet.
- Observed behavior
- The legacy ActiveX Date and Time Picker is missing from the 64-bit version of Excel, and the Office Store is blocked or unavailable, preventing the installation of modern web add-ins.
Confirm whether you are running a 32-bit or 64-bit version of Microsoft Excel (via File > Account > About Excel) and ensure your Microsoft 365 account is fully activated with a stable internet connection.
Enable Web Add-ins via Trust Center Settings
Since the legacy ActiveX date picker is inherently incompatible with 64-bit Excel, you must use a modern web add-in. This solution unblocks access to the Office Store so you can download a new date picker.
Microsoft permanently removed the legacy 32-bit Date and Time Picker (MSCOMCT2.OCX) in 64-bit versions of Office. The official workaround is to install a modern calendar add-in from the Office Store. If the store is blocked, you must adjust your Trust Center settings.
Launch Excel and navigate to File > Options. In the Excel Options dialog box, select Trust Center from the left-hand menu, then click the Trust Center Settings button.
In the Trust Center window, select Trusted Add-in Catalogs from the left sidebar.
Locate the checkboxes for 'Don't allow any web add-ins to start' and 'Don't allow web add-ins from the Office Store to start'. Ensure both of these options are unchecked, then click OK to apply the changes.
Sign out of your Microsoft account in Excel, restart the application, and sign back in. Go to Insert > Get Add-ins to open the Office Store and search for 'Mini Calendar and Date Picker' to insert a modern calendar control.
Reset Microsoft 365 Activation and Credentials
If adjusting the Trust Center settings does not restore access to the Office Store, resetting your Microsoft 365 activation state can clear authentication glitches preventing add-in downloads.
Need a simpler spreadsheet experience? Try WPS Office
If you are frustrated by missing ActiveX controls, legacy 64-bit compatibility limitations, and complex Trust Center settings in Microsoft Excel, WPS Office provides a lightweight, highly compatible alternative for your spreadsheet needs.
- 1. Download WPS Office: Visit the official WPS Office website and click 'Free Download' to obtain the unified installer for Windows.
- 2. Install the Software: Run the downloaded setup file and follow the on-screen instructions to quickly install WPS Office on your device.
- 3. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files to enjoy a seamless, error-free editing experience.
Frequently Asked Questions
Why is the Microsoft Date and Time Picker Control 6.0 missing in Excel?
The Date and Time Picker control relies on a 32-bit library file (MSCOMCT2.OCX). Microsoft never released a 64-bit version of this specific ActiveX control, making it natively unavailable in any 64-bit installation of Microsoft Office.
How can I add a calendar to 64-bit Excel without ActiveX?
Instead of using the legacy ActiveX control, you can navigate to Insert > Get Add-ins in the Excel ribbon. Search the Office Store for 'Mini Calendar and Date Picker' or similar web-based add-ins to insert a modern calendar.
Why does Excel say my Office Store add-ins are disabled?
This error typically occurs when specific security restrictions are enabled. You can fix this by navigating to File > Options > Trust Center > Trust Center Settings > Trusted Add-in Catalogs, and unchecking the options that block web add-ins from the Office Store.
