logo ASAP Utilities

“Love how easy it makes Excel for me!”

Excel with ASAP Utilities in it's menu

Version history

A history of the various updates and improvements throughout the years

Awards & Reviews

Read the awards & reviews from magazines, newsletters and radio shows.

Reviews from users

See what our users are saying about ASAP Utilities

Receive our newsletter

Receive an email as soon as a new version of ASAP Utilities is released

Trusted daily by over 26,000 organizations

Our list of clients exceeds 26,500 organizations in more than 140 countries.

ASAP Utilities 4.2.1 has been released today!

Date: November 14, 2007

New version of ASAP UtilitiesWe're proud to officially announce the new version of ASAP Utilities!

You can download 4.2.1, November 14, 2007.

This new version is improved in a few ways.
We recommend especially people with Excel 2007 to upgrade to this new version.

I would like to thank everybody for their feedback the past months!

If you would like to be informed by email when a new version is released, you can subscribe to our newsletter.


New/improved in this version

  • Fill » Random numbering of cells (without duplicates)
    Improved speed
  • ASAP Utilities Options » (Re) build the ASAP Utilities favorites menu toolbar
    Create or update a toolbar with the buttons/tools from your favorites menu. The toolbar is automatically updated when you change your favorites menu or your shortcuts to the tools from ASAP Utilities
    (Re) build the ASAP Utilities favorites menu toolbar
  • Format » Copy a sheet's page and print settings...
    Slightly improved speed. Furthermore it displays the current printer at the bottom. The speed of changing the page-setup in Excel might depend on the printer you currently have active. I will write more about this...
    The speed of changing the page-setup in Excel might depend on the printer you currently have active
  • =ASAPRandomPassword(length, use_symbols)
    This new function will return a strong password which contains of
      - both uppercase and lowercase letters
      - numbers
      - symbols, such as ~ ! @ # $ % ^ & * ( ) [ ] \ / < > : - = + _

    lenght:       The length of the password. If omitted the length will be 8 characters. If the length given is less then 8, still a password of 8 characters will be returned.
    use_symbols:  Use symbols in the password. Recommended for strong passwords. If omitted the password will contain symbols (special characters)

    Examples of created passwords:
    =asaprandompassword()                        4j:4Js29
    =asaprandompassword(8,FALSE)          dvU57E6u
    =asaprandompassword(8,TRUE)           -\D5t0:3
    =asaprandompassword(14,FALSE)         55GHo1sM85j9Le
    =asaprandompassword(14,TRUE)          89eTgLq\_46woE

    This function can be easy if you need a random password, or for example of you are a system administrator and need to create 50 random passwords for new email addresses.
    Example of the function =asaprandompassword()
  • Format » The smart difference...
    Contains a new option to apply colorbanding. Based on the information of data in a column you can have alternate colors to visualize the differences of data-groups.
    The smart difference contains a new option to apply colorbanding to groups
  • General
    A few small improvements.

Bugs fixed

  • Sheets » Freeze panes on multiple sheets at once
    Improved. The wrong range was freezed when the selected range on the other sheet was not in the "visible area". This is now fixed
  • System » Save file and create backup
    Fixed the bug where in Excel 2007 the point was removed before the extention in the name of the backup. When the filename had an extension that was not 3 characters, for example xlsx in stead of xls it goes wrong. For example book1.xlsx became in the backup folder: Book1 (backup 2007-10-01 08.25.31)xlsx; no piont before xlsx.
  • Excel 2007 ribbon
    I have removed the dynamic getScreentip for the buttons. This caused empty Visual Basic popups when you wanted to customize the ribbon (quick access toolbar, qat) and choose "all commands". The same goes for the getImage tag. If you first select the ASAP Utilities tab and then customize the ribbon it is okay, if you directly customize the ribbon you will still see one empty Visual Basic error. However this error has no effect on how things work.
  • Excel 2007 on Windows XP
    Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer.
    blog/index.php/2007/10/12/fix-excel-2007-explorer-startup-delay/
  • General
    Fixed a few small bugs and typing errors.


« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


Empowering Excel Users Worldwide for 25 Years