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.2 (August 16, 2019) – current version

  • 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.