Microsoft Date and Time picker not working in Excell 365 Pro Plus

Question

_{Tuesday, April 7, 2020 8:11 AM}

Hi all,

I have got a new pc at work with (probably) other version of Office (365 Pro Plus), and, in older excell sheets I have created I am not able any more to see Date and Time picker in Developer tab. It is not even showing there.

Can I somehow add it, or, is there other way around to use it? How can I see with this version of Excell date and time picker in older sheets already created?

Thanks for any tips!

Miro

All replies (3)

_{Wednesday, April 8, 2020 3:10 AM}

Hi Miro,

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. Even if 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. For more information, you can read the 3rd-party article: How to create calendar in Excel (drop-down and printable).

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Based on my tests, I created a date control in Excel 2010 and save it. Then, I could open it in Excel 2016 and Office 2019(VL, 32-bit edition) and pick a date to update the control. However, I found that it didn't work in Excel for Office 365 and 64-bit version of Office 2016/2019. I couldn't pick dates at all.

If you want use date picker, you can get add-ins from Office store:

Hope the information was helpful. Any updates, feel free to post back to let us know.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Monday, April 13, 2020 10:53 AM}

Hi,

I am checking the status of this issue. Do you have any update for it?

If the replies are helpful to this question, please remember to mark them as answers. Your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding.

Anything unclear or any questions, feel free to post them back to let us know. I will be glad to follow up and help you.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Monday, April 20, 2020 9:50 AM}

Hi,

This thread has been around for a long time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

Thank you for understanding! If you have any questions, or updates, please feel free to let me know.

Best Regards,

Herb

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.