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 (18.2 MB) attached.

Not able to download?

We can send you the new version by email. The file is 2.5 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.8 released!

In this newsletter

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

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

Upgrade to the new version

New and improved utilities

• Objects & Comments » Delete all objects on current worksheet
  This utility can now be used on multiple worksheets and has been renamed to:
  Delete all objects in selected worksheets
  
• ASAP Utilities Options » Start the last used utility again...
  This now is the default 'repeat' action after a tool in ASAP Utilities has been used so that you can also use it from the Excel menu (Edit > Repeat) or with Excel's built-in shortcuts F4 or Control+Y.
  

Bug fixes

• Range » Move selected range (only values)...
  Didn't work in Excel 2000. This is now fixed
  (Error 438: Object doesn't support this property or method)
• Objects & Comments » Delete all objects on current worksheet
  This utility also removed the comments on your sheet. However the "comment-indicators", the triangles, were still shown by Excel. It could happen then when you click on a cell to view the comment that Excel would crash.
  The utility has now been updated so that al objects, except the comments, are removed.
• Fill » Insert before current value...
  Didn't always work on very long cells. In such a case it could produce an error and ASAP Utilities stopped working and you had to restart Excel to get ASAP Utilities working again. This is now fixed.
• Web » Convert hyperlinks to =HYPERLINK() formulas
  Fixed the error that occurred when a cell in your selection contained a double quote ("). A few small improvements were made too.
• Range » Find / Replace in all sheets...
  Fixed a bug when you could get an error with certain cell with long contents.
  Furthermore the formulas in the results will now be displayed using your Excel's country settings instead of in the US/English notation.
• Text » Advanced character removal/replace...
  Fixed a bug when nothing was removed/replaced in certain cells with long contents.
• Columns & Rows » Conditional row and column select, hide or delete...
  The option 'every n'th row/column number' disappeared when you changed the option to handle 'rows' to 'columns'. This is now fixed.
• Range » Advanced sorting...
  Fix the bug that sometimes occurred during the startup of the utility and produced an error such as "Error 424: Object Required" or "Method '~' of object '~' failed, Error -2147221080: Automation error"
  This error could happen if you used the utility on a workbook, then closed that workbook and then used this sorting utility again.
• General
  A few spelling errors were corrected.

Bug fixes in version 4.2.7

• Columns & Rows » Conditional row and column select, hide or delete...
  When the option to delete/remove duplicate rows or columns was selected the utility didn't do anything. This bug was introduced in version 4.2.6 and is now fixed.
  

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 the following currencies: US Dollar (USD), Euro (EUR), Pound Sterling (GBP), Australian Dollar (AUD), Canadian dollar (CDN), Swedish Krona (SEK), New Zealand Dollar (NZD), Norwegian Krone (NOK), Yen (JPY), Hong Kong Dollar (HKD), Danish Krone (DKK), Swiss Franc (CHF), Rand (ZAR), Singapore Dollar (SGD) and Yuan Renminbi (CNY)
• 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