Changes in version 8.5 - February 29, 2024

Finished

We're launching version 8.5 of ASAP Utilities on the most magical day of the year - February 29th!
Just like this leap day gives you an extra 24 hours, our Excel add-in gifts you extra time all year round.

Supported Excel versions

ASAP Utilities 8.5 works with:

• Excel 365 (both 32- and 64-bit version)
• Excel 2021 (both 32- and 64-bit version)
• Excel 2019 (both 32- and 64-bit version)
• Excel 2016 (both 32- and 64-bit version)
• Excel 2013 (both 32- and 64-bit version)
• Excel 2010 (both 32- and 64-bit version)

On any Windows system that matches the Excel system requirements.

New/improved

Text  ›  7. Change Case (with options)...

Improved the "Set words to preserve/exclude" setting. 
In addition to a space, it now also detects separate words based on any of the following characters: . ' ] ) ) { } : [ ( ; "

General

• Fixed some known small issues and made a few small improvements.
• Developed a fix for the issue where Excel sometimes stopped displaying the ASAP Utilities progress bar during processing.

ASAP Utilities Options  ›  1. Settings, language and contact information...

Microsoft Office's Visual Basic for Applications (VBA) still does not natively support mouse wheel scrolling in UserForms/dialog boxes.
This has been a request to Microsoft for decades already. Users requested it to us too, and since Microsoft still hasn't implemented it, we investigated and implemented a workaround for this in ASAP Utilities.
You can now enable this via the option: Enable mouse wheel scrolling for dialog boxes

There appears to be a bug in certain Excel 365 builds(source 1, source 2) which currently may cause this new functionality to crash those Excel builds/versions, so be careful when you try it the first time.
To try it, just enable the option, click OK, close the settings window, and then for example choose ASAP Utilities  ›  Info...
If that crashes Excel (sometimes you see a cryptic Microsoft Visual Basic for Applications - Unexpected error (35010), go back to the options and turn off this setting until you have updated your Excel version/build.

Free upgrade if you purchased your license in 2016 or later

If you purchased your license in 2016 or later (version 7.x) then you get version 8.5 free of charge. You can use the same license details.
If you purchased a license longer ago, then please contact us for a 50% discount to upgrade to versions 8.

To upgrade to a newer version of ASAP Utilities that is covered by your license, just install the new version "on top" of the existing version on your computer.
ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.