Release notes

We recommend that you keep XLTools add-in up to date. The most recent version always has new and improved features and is 100% compatible with Excel and Windows updates.

Check for updates: Excel > XLTools tab > ‘Help’ button > Check for updates.

Check your version: Excel > XLTools tab > ‘License’ button.


Version 5.1.3 (September 3, 2019) – current version

  • Fixed a bug with the automation command XLTools.CombineSheetsData: combining sheets does not duplicate data now.
  • Added a drop-down option to the Workbook Organizer button: ‘Open folder of this workbook’. Clicking the option will quickly open the location folder of the active workbook.
  • Simplified navigating worksheets with the Sheet Switcher for workbooks with 10 and more worksheets.
  • Improved inserting date & time with the Popup Calendar.
  • Improved the Mail Merge feature. Now a list of recipients can be created in an unsaved yet workbook. Fixed the error ‘Object reference not set to an instance of an object’ – it appeared when some column headers in the list of recipients were blank.
  • Added a troubleshooting solution for the installation error ‘Customized functionality in this application will not work because the certificate used to sign the deployment manifest or its location is not trusted’. The error will not appear if our website is saved to the list of trusted websites.
  • Fixed minor bugs with buttons display: Free Trial button on the ribbon, Popup Calendar & Clock icons in the context menu.

Note for registered users:

Registered users can use this offline installer for XLTools version 5.1.3. Use your purchased license key to activate the add-in.

Download version 5.1.3 (offline installer)

Сlick the link > Save File > Open ‘This PC (My Computer)\Downloads‘ > Right-click and Extract files > Find ‘XLTools.exe’ > Double-click to run the installer > Install.

Version 5.1.2

  • Common error messages what appear in SQL queries, Version Control and Mail Merge now contain recommendations how to solve the issue.
  • Fixed a bug in the Export to CSV feature. Now exporting dates in a long-date format runs smoothly.
  • Optimized performance of the Combine sheets feature. Now it combines even a large number of sheets much faster and with no errors.
  • Fixed Mail Merge bugs with the disappearing TLS/SSL checkbox and non-stretchable Send Emails form.
  • Fixed Version Control errors that prevented comparing versions if the worksheet contained a named range.
  • Fixed a bug in the Popup Calendar running on Windows 7, when the calendar blocked cell selection.
  • Improved overall performance.

Version 5.1

  • Introduced a new installer. Any lacking Microsoft prerequisites will be installed at the same time.
  • Improved the process of updating to a new version, added the ‘Check for Updates’ button to the ribbon.
  • Automated launching of the free trial. Now the trial activates immediately after installation of the add-in.
  • Added an automatic license key lookup tool to the website.
  • Fixed errors and bugs to improve performance.

Version 5.0

  • Developed 7 new features: Popup Clock, Disable F1/F9, Fill Blanks, Combine Sheets, Workbook Organizer, Count by Color, Split Table.
  • Simplified range selection controls to support automatic selection of tables and ranges.
  • Improved interaction with dialogue boxes, standardized and fixed them on top of Excel interface.
  • Expanded the Mail Merge functionality: add file attachments to bulk emails, format email template text.
  • Fixed commit changes error in Version Control.
  • Added new options to the Popup Calendar and Clock: set custom date/time format, open on the last used value.
  • Expanded the Unpivot Table functionality: preserve table headers, duplicate data from merged cells, preserve cell formatting.
  • Improved the Sheet Switcher design, added hot keys to navigate up/down the list of worksheets.
  • Improved overall usability, updated ribbon structure and tooltips.
  • Fixed errors and bugs to improve performance.

Note for registered users: learn how to upgrade to XLTools 5.0.

Learn moreLearn more

Version 4.1

  • Developed new feature: Version Control for VBA macros to track and compare changes in code.
  • Expanded Version Control functionality to preview and diff changes before committing a version.
  • Simplified Version Control settings: committing a version always requires a comment.
  • Version Control regularly checks and deletes Temp files generated during work.
  • Developed and released first XLTools version for terminal servers.
  • To prevent Excel crashes, the add-in gets disabled in linked or embedded tables Word.
  • Included notifications about XLTools available updates.
  • Fixed installer errors and bugs to improve performance.

Version 4.0

  • Updated XLTools ribbon.
  • Simplified download and activation of a free trial with full access to all XLTools features.
  • Adopted changes to licensing and purchasing procedure, EULA and Privacy Policy.
  • Changed XLTools update procedure from automatic update to an update upon user confirmation.
  • Introduced new installer logic to prompt installation of Microsoft prerequisites.
  • Fixed bugs to improve performance.

Note for registered users: learn how to upgrade to XLTools 4.0.

Learn moreLearn more

Version 3.6

  • Changed the logic of XLTools.exe installer to bootstrap necessary Microsoft prerequisites.
  • Fixed installation errors for 32-bit systems.
  • Fixed ‘timeout’ error in Version Control.
  • Updated Mail Merge with the option to clear previous SMTP settings.
  • Fixed distorted License window display.
  • Eliminated the cause for slow switching between worksheets in the taskbar.
  • Fixed minor bugs.

Version 3.5.6

  • Updated components to ensure XLTools compatibility with Windows 10.
  • Updated components to ensure XLTools compatibility with Excel 2016.
  • Introduced a free trial system with automatic emailing of trial keys after downloading XLTools.
  • Improved Version Control performance with workbooks containing protected sheets and chart sheets xlChart.
  • Fixed the Popup Calendar settings to display/hide in the right-click context menu.
  • Included an error message when the Popup Calendar is used in the right-to-left worksheet layout (Arabic view).
  • Eliminated the cause for slow reaction when opening right-click menu and hide/unhide commands.
  • Updated Microsoft security certificate for XLTools.
  • Fixed VSTO errors during installation related to system security and invalid manifest.
  • Fixed minor bugs to improve performance.

Version 3.5

  • Developed and released new features: Export to CSV, Automation without macros.
  • Improved the SQL Queries feature to support various data formats, including dates.
  • Refined error messaging for wrong syntax in SQL Queries.
  • Included week numbers in the Popup Calendar interface.
  • Added the option to insert current date and time directly from the Popup Calendar interface.
  • Expanded the Popup Calendar settings with the option to set default date format.
  • Added the Popup Calendar option to auto-increment dates when populating a range of cells.
  • Expanded the Unpivot Table functionality to convert even complex crosstab tables with multilevel headers to a flat list.
  • Added the possibility to automate importing of SendGrid reports to Excel.
  • Expanded Version Control settings to save a new version via the ‘Commit Changes’ button.
  • Included the possibility to resize License window.
  • Fixed minor bugs to improve performance.

Version 3.0

  • Developed and released new features: SQL Queries, Combine Cells Data, Columns Match, Mail Merge.
  • Expanded Version Control functionality to compare different versions and highlight changes.
  • Improved performance of the SQL Queries feature and messages on syntax errors.
  • Improved the Data Cleaning feature.
  • Improved performance of the Popup Calendar when the freeze panes mode on the worksheet is enabled.
  • Added the option of assigning Shortcuts to XLTools features.
  • Reassembled XLTools.exe installer.
  • Updated Microsoft security certificate for XLTools.
  • Fixed minor bugs to improve performance.

Version 2.0

  • Developed and released new features: Version Control, Repeat Selection, Data Cleaning, Unpivot Table.
  • Added the new option to the Popup Calendar to display the Calendar icon near cells with dates.
  • Fixed errors in download process from the website.
  • Fixed minor bugs to improve performance.

Version 1.0 (October 2013)

  • The first XLTools release featured the Popup Calendar and the Sheet Switcher.
  • Improved download, installation and performance of the add-in after beta-testing.

Comments are closed.