Sit down and relax while ASAP Utilities does the rest!

User Guide

The ASAP Utilities User Guide (PDF) is a practical manual that will show you how to get the best out of this excel add-in.
To receive the User Guide by mail, send an email to
userguide@asap-utilities.com and you will get an automated reply with the file (8.4 MB) attached.

Not able to download?

We can send you the new version by email. The file is 1.9 MB
Send your request to:
download@asap-utilities.com
This setup does not include the User Guide.

Installation

It is not necessary to uninstall the previous version before installing the new one. Make sure Excel is closed and then run the setup.

Uninstall

If you want to uninstall ASAP Utilities, use the option "remove ASAP Utilities from your computer" in your ASAP Utilities start menu. Detailed information is also available on our website and in the User Guide.

Upgrade twice a year

Since 2001 it's our policy to force an upgrade (free) every half year to make sure you are always using the best and most complete version.

Purchase ASAP Utilities

Read the benefits and buy a license online.
Safe secure and fast

New ASAP Utilities version 4.2.4 released!

In this newsletter

• Upgrade to the new version
• What's new
• Bugs fixed in version 4.2.4
• When to buy a license

“We make you the company's Excel guru!”

Upgrade to the new version

New and improved utilities

• Export » Export selection or active sheet as new file...
  The default file extension for tab separated files is now tsv instead of txt (tsv stands for tab separated value)
• Export » Export worksheets as separate files...
  The default file extension for tab separated files is now tsv instead of txt (tsv stands for tab separated value)
• Formula » Convert formulas to their values
  Improved so that it now works on filtered data too.
  Normally the utility changes the formulas to their calculated values in all selected cells (hidden or not). If you have selected cells in a filtered list only the visible cells are affected.
• Web » Activate hyperlinks (create from cell values)...
  Improved, you can now choose to use the "regular" hyperlink or to use the =HYPERLINK() formula to create the hyperlinks. The formula-method is preferred for shared workbooks and when it involves a large amount of hyperlinks.
  
• Columns & Rows » Put together rows or columns from several sheets...
  The column width of the original data is now copied too.
• Export » Export selected chart or range as image (file)...
  You can now choose whether you want to have the utility automatically closed after the export is created.
  
• Fill » Insert before current value...
  Fill » Insert after current value...
  You can now choose to skip empty cells in your selection. There is also a 'reset' button added that will clear the insert before and after values and reset the options to their defaults. Because your previous settings are always remembered this can be handy.
  
• Web » Extract hyperlinks...
  Your last used settings are remembered.
• Fill » Add leading zeros...
  has been renamed to:
  Fill » Fill up with leading zeros...
  We think this is a better description of what the utility does; Fill the current value with leading zeros up to the total length you specify. For example if you enter 3, the number 1 becomes 001 and 11 becomes 011. If you enter 6, the number 1 becomes 000001.
• Format » The smart difference...
  has been renamed to
  Format » Detect and visualize adjacent data/group changes
  to better reflect what the utility does
• New worksheetfunction =ASAPISBOLD()
  Returns true of the referenced cell is bold.
• General
  Several minor improvements

Bug fixes

• Format » Copy a sheet's page and print settings...
  In Excel 2007 this utility could make Excel crash.
  This is now fixed by creating a workaround for Excel 2007.
• Format » Empty all headers and footers
  In Excel 2007 this utility could make Excel crash.
  This is now fixed by creating a workaround for Excel 2007.
• Export » Export worksheets as separate files...
  Improved so that it ignores other applications/add-ins during the process.
  This solves a problem the add-in XLplus could cause when also installed.
  A few other minor bugs have been solved too.
• Export » Export selection or active sheet as new file...
  Improved so that it ignores other applications/add-ins during the process.
  This solves a problem the add-in XLplus could cause when also installed.
• Select » Conditional row and column select, hide or delete...
  The progress indicator when searching for duplicates wasn't properly shown, this is now fixed (and improved for removing duplicate)
• Import » Insert Excel File...
  Fixed the incorrect message that the file was opened instead of imported. Further improved so that if you just started Excel with a blank workbook, the file is imported in stead of opened.
• Range » Find / Replace in all sheets...
  When you pressed the "Find all" button you immediately got 
  Error 401: Application-defined or object-defined error.
  This is now fixed. (this bug only existed in version 4.2.2.)
  
• Favorites menu
  Fixed the bug where in some cases you got an error stating that ASAP Utilities can't access the favorites folder.
• Import » Insert (delimited) text file...
  Fixed the bug when imported date values where not displayed as dates (cell formatting) but displayed as numbers instead.
• Fill » List filenames in folder...
  Fixed the bug where in column B the filename was listed including its full path when the option to create hyperlinks to the files was checked. This is now corrected.
• General
  The favorites menu can now be located on a network path, such as \\server2\user\data\
  If your worksheet contained wrong macro code (for example plain text instead of proper code) you got the error that a worksheet wasn't selected. This is because due to the bad macro code in the sheet certain actions cannot be done.
  The message is now updated so that it will inform you properly about this and suggest that you reopen your workbook without enabling the macros.
  Several minor bugfixes

When to buy a license?

• if you use it for commercial purposes (Feel free to try it for 90 days. If you like it, simply purchase a registration key online via our e-commerce partner RegNow)
• or if you don't want to be forced to update to the new version twice a year
• or if you like this program and think it is worth the money

Key benefits of registration

• use it in a commercial organization
• no forced updates twice a year
• priority support via email
• free upgrade to all 4.x versions

Online ordering, safe secure and fast

• Single user license: US $49.00
• The price is a one time fee, not a yearly subscription.
• We offer generous volume discounts (save 20% to 86%)
• You can pay in US Dollar, Euro, Pound Sterling, Australian Dollar or Canadian dollar
• There is no shipping or handling fee
• You can also get ASAP Utilities on a cd-rom by postal mail for an additional USD 12.50
• After the order is completed you get your registration code within a few minutes.

Instant delivery

More information and demonstration