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.5 - December 8, 2017

Date: November 16, 2017 (last updated on December 8, 2017)
reference id: QA0306

Pre-release

We're currently working on the new version 7.5 which has a few improvements and is now available as a pre-release.
ASAP_Utilities_7-5_RC8_Setup.exe 12.3 MB (December 8, 2017)

To upgrade, just install the new version "on top" of the existing version on your computer.

Supported Excel versions

ASAP Utilities 7.5 works with:

  • 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 365 (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.4 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

Both editions:

  • General
    A few small improvements.

"32-bit edition" only:

  • General/startup
    Starting from November 8, we were contacted by about ten users that suddenly ran into an issue with their ASAP Utilities in combination with Excel 2016 32-bit. That seemed to be caused by a recent Microsoft update.
    Unfortunately we haven't been able to reproduce this on any of our test or production systems so far, but in corporation with these users we've found a workaround for it.
    In case you get the following error, then please install the preview edition of ASAP Utilities 7.5 or choose to install the "32-bit + 64-bit edition" of version 7.4.
    "Sorry, something went wrong in the ASAP Utilities.xla auto_open() event, build menu.
    -2147417848: Method 'ASAP_Utilities_MenuBuilder' of object '_CPublic' failed on line 670"

    In addition, we also recommend to keep your Office up to date, because the Microsoft team is continuously working on it:
    # The importance of Microsoft Office Update | Fix random crashes
    http://www.asap-utilities.com/blog/index.php/2017/10/30/the-importance-of-microsoft-office-update/
    # Microsoft: Fixes or workarounds for recent issues in Excel for Windows
    https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Excel-for-Windows-49d932ce-0240-49cf-94df-1587d9d97093

"32+64-bit edition" only:

  • Select » Select cells based on content, formatting and more...
    All available select options in the drop-downs are now numbered.
    Six new options added, where you can select cells based on multiple values at once.
    These values can be in a range of cells in your workbook.
    You can use this for example to select negative keywords in a large dataset.
    1. contains any of the values specified in a range
        searching for "test" selects cells with values such as "This is a test" or "Testing now"
    2. does not contain any of the values specified in a range
        searching for "test" selects cells without the text "test" in it.
    3. contains any of the full words specified in a range
        searching for "test" selects cells with values such as "This is a test" or "Ready (test)"
        searching for "test" does NOT select cells with a value such as "We're testing this"
    4. does not contain any of the full words specified in a range
        searching for "test" does NOT selects cells with values such as "This is a test" or "Ready (test)"
        searching for "test" does select cells with a value such as "We're testing this"
    5. equals a value specified in a range
        searching for "test" selects cells with the value "test" only.
        searching for "test" does NOT select cells with a value such as "test 123"
    6. does not equal a value specified in a range
        searching for "test" does NOT selects cells with the value "test" only.
        searching for "test" selects any cell that has not the same exact content, such as "test 123"
  • General
    When you used the Preview pane in Windows File Explorer, in some situations Excel showed a "Run-tim error '50290': Method 'Saved' of object '_Workbook' failed" error. We've created a workaround/fix for that.

 






« back

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - 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