Talk to experts about Microsoft Office 2019. Visit the dedicated forum to share, explore and If you have feedback for TechNet Subscriber Support, to learn more. Mark the replies as answers if they helped. Any updates, feel free to post back to let us know. If you want use date picker, you can get add-ins from Office store: However, I found that it didn't work in Excel for Office 365 and 64-bit

Then, I could open it in Excel 2016 and Office 2019(VL, 32-bit edition) and pick a date to update the control. Microsoft does not guarantee the accuracy of this information.īased on my tests, I created a date control in Excel 2010 and save it. Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. To create calendar in Excel (drop-down and printable). For more information, you can read the 3rd-party article: How You add a reference to mscomct2.ocx/mscal.ocx in Excel 64 bit, it will still return the 'Could not load an object because it is not available on this machine' error.

However, google could show you third-party solutions like this one https. For my knowledge Microsoft has no in-box solution for 64bit version (as data picker for 32 bit). Subscribe to RSS Feed Mark Discussion as New. As far as I know, Microsoft Date and Time Picker Control 6.0 is an old control and it has been removed from Office since Office 2016. Although you can register the calendar control for Windows 64 bit, it will work for Office 32 bit only. Add drop down calendar to Excel 2016 64 bit Add drop down calendar to Excel 2016 64 bit.

Excel date picker in cell 64 bit