今天在一台虚拟机上面,打开一份Excel表格,无法显示里面的日期控件,检查了一下,发现是Excel里面没有注册Microsoft Date and Time Picker Control 6.0(SP6)控件。后来通过下载控件手动注册后解决问题。 做个记录,以免遗忘。 操作系统:Windows Server 2008 R2
I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly: https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker ...
Dear guys, The Microsoft Date and Time Picker Control 6.0 (SP6) not listed in the "More Control" list .. and I'm not able to use the datepicker control. I'm using Excel 2010 (32-bit) running on windows 10 (64-bit) Would you please help me on that?
在功能区中,单击控件组右下角的下拉按钮以展示所有控件,然后从选项列表中选择"ActiveX 控件"(见图 3)。 图3. ActiveX 控件选项 在"插入活动控件"对话框中,向下滚动以查找 Microsoft Date and Time Picker Control 6.0 (SP4)(您计算机上的该控件可能具有更新的 SP,如 SP6),然后单击"确定"以插入该控件(见图 ...
I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly: https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker...
I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly: https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-pick...
在"插入活动控件"对话框中,向下滚动以查找 Microsoft Date and Time Picker Control 6.0 (SP4)(您计算机上的该控件可能具有更新的 SP,如 SP6),然后单击"确定"以插入该控件(见图 4)。请注意,您的可用控件列表可能与此图不符。 图4. Microsoft Date and Time Picker 控件 ...
Hi, i am using Excel 2016 64 bits. How can i install Date and Time Picker Control? Tuesday, August 6, 2019 8:33 PM neither am I could do this (Windows 10 x64 and Office 2019 x64). But I found the best alternative right here :) ...
在"插入活动控件"对话框中,向下滚动以查找 Microsoft Date and Time Picker Control 6.0 (SP4)(您计算机上的该控件可能具有更新的 SP,如 SP6),然后单击"确定"以插入该控件(见图 4)。请注意,您的可用控件列表可能与此图不符。 图4. Microsoft Date and Time Picker 控件 ...