Hi All, I've made a sheet with a date picker that works fine, but when the book is reopened the picker doesn't work until I click 'Source' in the developer tab at which point it comes to life and works perfectly. Date Picker is a drop-down calendar that helps entering dates in Excel. Just run the calendar and click the needed date to get it automatically inserted into the selected cell. Date Picker will assist if you need to add and subtract years, months, weeks, and days from the chosen date and paste the result into the chosen cell. Removing it should be simple. An Excel Addin is just an Excel file with an Xlam extension. First disable it in Excel by in your Excel file click the File Tab - Options - Add-Ins - Make sure the Manage Addins is set to Excel Add-ins - click Go - find the Addin in the list and clear the checkbox - click OK.
Ed has three computers at work. 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. He wonders how he can load this tool into Excel 2010 and Excel 2013.
According 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. In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX.
You can tell if you already have the new date picker installed by following these steps:
- Display the Developer tab of the ribbon.
- Click the Insert tool. Excel displays a palette of tools you can insert in your worksheet.
- In the ActiveX Controls section of the palette, click the More Controls option. (It is the very bottom-right tool.) Excel displays the More Controls dialog box.
- Scroll through the dialog box until you find the Microsoft Date and Time Picker tool. Select it.
- Click OK.
If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system. If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems. (In fact, none of the ActiveX controls work in 64-bit Office. When Microsoft actually comes out with versions of the controls that do work with 64-bit Office, they will likely have different names, a move sure to complicate the life of VBA programmers who rely on the controls.
If you are running a 32-bit version of Office, then you can try to copy the MSCOMCT2.OCX control from a like system and register it with Windows. (Before copying it, do a Windows search to see if the file is actually on your system. If it is, skip copying and just try to register it.)
How you register the control depends on the version of Windows you are using and whether you are using a 32-bit or 64-bit version of the operating system. (Don't confuse the number of bits in the operating system with the number of bits in your copy of Office; they are two different things.) A good overview of how to register the control can be found here:
Quickly enable date picker (drop down calendar) for date cells in Excel
Kutools for Excel
In general, you can type in a new date to overwrite the existing one in Excel easily. However, how could you quickly figure out the last Thursday of the current month and type in it? Here, Kutools for Excel released the Date Picker feature to show a drop-down calendar beside the currently selected date cell, so that you can quickly find out the last Thursday of the current month, and click it to overwrite the original date at ease.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Usage
This section will guide you to enable and use the date picker in Excel.
Date Picker Excel 2017
1. Click Kutools > Content > Enabled Date Picker to turn on the Date Picker feature.
2. Then you can apply the Date Picker feature as follows:
(1) Select a date cell to show the calendar icon right to the date cell.
(2) Click the calendar icon to show the drop-down calendar.
(3) Click a date in the drop-down calendar to replace the original date immediately.
(1) Select a date cell to show the calendar icon right to the date cell.
(2) Click the calendar icon to show the drop-down calendar.
(3) Click a date in the drop-down calendar to replace the original date immediately.
Tips: In the drop-down calendar, you can click to recover the original date.
3. Click to close the drop-down calendar.
Notes
1. The Date Picker feature supports undo. If you did not undo in the drop-down calendar, you can also click or press Ctrl + Z to recover the original date.
2. The Datepicker Excel X64
![2016 2016](/uploads/1/1/8/7/118768140/854978560.jpg)
Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.
Kutools for Excel
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.
Date Picker Excel File
or post as a guest, but your post won't be published automatically.
Datepicker Excel Download
Loading comment... The comment will be refreshed after 00:00.