

(In fact, none of the ActiveX controls work in 64-bit Office. The reason is because MSCOMCT2.OCX works only on 32-bit systems.

#Put drop down calendar excel 2016 install
If you are using a 64-bit version of Office, then you won't be able to install the control. If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool.(It is the very bottom-right tool.) Excel displays the More Controls dialog box. In the ActiveX Controls section of the palette, click the More Controls option.Excel displays a palette of tools you can insert in your worksheet. Display the Developer tab of the ribbon.You can tell if you already have the new date picker installed by following these steps: In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX. He wonders how he can load this tool into Excel 2010 and Excel 2013.Īccording to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of Office. One has Excel 2010 with the Date Picker tool but the other two, one with Excel 2010 and one with Excel 2013, do not have this tool available.
