logo ASAP Utilities

Receive our newsletter

Get an email when a new version of ASAP Utilities is released

RSS Feed

The new version will be announced in our news RSS feed.

Pre-release version 7.7.1 - May 2, 2020

Date: March 27, 2020 (last updated on May 2, 2020)
reference id: QA0324

Pre-release

We're currently working on the new version of ASAP Utilities, which is available as a pre-release:
ASAP_Utilities_7-7-1_RC11_Setup.exe 27.1 MB (May 2, 2020)

Supported Excel versions

ASAP Utilities 7.7 works with:

  • Excel 365 Desktop edition (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)
  • Excel 2007
  • Excel 2003
  • Excel 2002/XP
  • Excel 2000

On any Windows system that matches the Excel system requirements.

Free upgrade if you purchased version 7.x or 5.x

If you purchased a license for version 7.x or 5.x, then you get version 7.7 free of charge. You can use the same license details.
If you purchased a license in 2012 or earlier, then please contact us for a 50% discount to upgrade to version 7.

To upgrade, 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.

New/improved

  • General
    A few small improvements and bug fixes based on the feedback from our users.
  • Web » Decode all URL and HTML encoded text
    Didn't decode all characters in 64-bits edition of Excel. This is now fixed.

Currently in the universal "32+64-bits edition" for Excel 2010 and later only:

  • New: Write out numbers in French
    Text » Spell/write out numbers or amounts (EN, DE, NL)...
    Has been renamed to "Spell/write out numbers or amounts (EN, DE, FR, NL)..." because the French language is added by request.
    You can now write out numbers/amounts  in French via this tool or by using the =ASAPSPELLNUMBER() worksheet function.
    New:
  • New, via ASAP Utilities Options » New tools in development (English only):
    "Remove duplicated values per row in your selection"
    This will remove the duplicated values per row in your selection.
    Quickly remove the duplicated values per row in your selection
  • New, via ASAP Utilities Options » New tools in development (English only):
    "Rename sheets"
    This allows you to quickly change the names of multiple or all sheets in your workbook at once.
    You can choose to add text at the en of the name of each sheet, add it at the front, perform a find & replace on the sheet names or name the sheets based on the values in a range.

    Quickly rename multiple sheets at once
    Quickly rename multiple sheets at once using Find & Replace
  • =ASAPGETCOMMENT(cell)
    This function now also returns the content of the new Excel 365 threaded comments when used.
    In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
    (Microsoft: The difference between threaded comments and notes)
  • Objects & Comments » Comment tools...
    "Extract/report content of comments" now also returns the content of the new Excel 365 threaded comments when used.
    In Excel 365 Microsoft now calls the legacy comments "notes" and has introduced a new style of comments.
    (Microsoft: The difference between threaded comments and notes)
  • General
    A few users got an "Can't find DLL entry point GetTickCount...." error
    That was caused by certain software that blocked access to standard Windows functionality.
    We've got this reported about 5 times, and the information on the following page helped the clients to solve it:
    https://forums.zotero.org/discussion/70171/word-windows-plugin-runtime-error-453
    In that case you may have to add ASAP Utilities to a whitelist in Cylance Protect
    https://threatvector.cylance.com/en_us/home/cylanceprotect-feature-release-macro-script-control.html
    In this new version of ASAP Utilities, we've used a workaround for this Windows timer function and also added some extra error handling to prevent that error from in case blocked.





« back

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2020 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook