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.2 released!

In this newsletter

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

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

Upgrade to the new version

New and improved utilities

• Export » Export worksheets as separate files...
  Improved, you can now specify in which file-format you want to save the sheets.
  If you have Excel 2000, 2002/XP or 2003 you can export the sheets in these formats:
    - Excel 97-2003 Workbook (*.xls)
    - CSV (Comma delimited) (*.csv)
    - Text (Tab delimited) (*.txt)
    - Text (Tab delimited unicode) (*.txt)
    - Text (Space delimited) (*.prn)
    - Text (Pipe delimited) (*.txt)
    - Text (Delimited by #) (*.txt)
    - DBF 4 (dBASE IV) (*.dbf)
    - DBF 3 (dBASE IV) (*.dbf)
  In Excel 2007 you can save the worksheets in the following file formats:
    - Excel 2007 Workbook (*.xlsx)
    - Excel 97-2003 Workbook (*.xls)
    - CSV (Comma delimited) (*.csv)
    - Text (Tab delimited) (*.txt)
    - Text (Tab delimited unicode) (*.txt)
    - Text (Space delimited) (*.prn)
    - Text (Pipe delimited) (*.txt)
    - Text (Delimited by #) (*.txt)
  
• Import » Insert (delimited) text file...
  Improved, the import of pipe-delimited files has been implemented and you can now have the imported data automatically trimmed (remove leading and trailing spaces).
  
• General
  If you install ASAP Utilities you can choose to have it automatically added to the Excel menu for each user that logs in on the computer. This is also handy when you log in with normal user-rights and run the setup as an administrator.
  
• Export » Export selected chart or range as image (file)...
  The dialog will now automatically be closed after the export is completed.
• ASAP Utilities Options » ASAP Utilities options and settings...
  You can now specify to have the menu-items (Categories) numbered too.
  By default this is turned on.
  
  
• Fill » List filenames in folder...
  Added the option to only list files that were created or modified a number of days ago.
  
• Fill » Quick numbering of cells...
  You can now specify how to increment the numbers. This used to be 1 (1,2,3 etc) but now you can enter your own value, for example 5 to icrement from 5 to 10, 15 etc.
   
• Numbers » Round numbers (not formatting, but changing)...
  Improved speed
• Sheets » Add sheets (with the names defined in selected cells)...
  You can now also choose to color the new sheet-tabs based on the cell colors.
  Colored tabs are available since Excel version 2002/XP.
  
  
• Sheets » Sorts all sheets in alphabetical order
  has been improved and renamed to:
  Sheets » Sort all sheets...
  You can specify to sort the sheets alphanumeric (text), numerically (numbers) or by their tab-color. You can also specify to sort the sheets ascending (A-Z) or descending (Z-A).
  To be able to sort by the tab-colors you need at leest Excel 2002/XP.
  
• Web » Decode all URL-encoded data
  Decode all URL-encoded data in your cells.
  This will replace the '+' with a space and decode any %## encoding in the cells, which can be handy when you use Excel to analyse website statistics and keyword performance.
  For example this utility will decode data like:
  %22Keyword%2Binfo%2C.%2F~%26ok%3F
  to:
  'Keyword+info,./~&ok?
  URL Encoding is used when placing text in a query string to avoid it being confused with the URL itself. It is normally used when the browser sends form data to a web server. URL Encoding replaces spaces with '+' signs, and unsafe ASCII characters with '%' followed by their hex equivalent.
• General
  Several minor improvements.
  The default location of the favorites menu file is no longer in the program files folder but instead in the user's application data folder.

Bug fixes in version 4.2.2

• Count duplicates
  Didn't work correctly if one of the values in the list started with the less then (<) or greater then (>) sign. For example a list with values 8370N, 8384N, >82821N, >83381N incorrectly tagged the last two values as duplicates.
  The utility didn't work correctly with large numbers. Numbers such as 162000205922.002500324327 and 162000205922.002500324329 were incorrectly marked as duplicate.
  The speed of the utility has been significantly improved.
• Formula » Change reference style (e.g. A1 to $A,1 etc.)...
  The option "Convert formulas to absolute rows and relative columns (A$1)" incorrectly changed the cell references to relative rows and absolute columns ($A1)
• Export » Export selected chart or range as image (file)...
  When you had a chart on a chartsheet and you had selected something within that chart, for example the chartarea, the export didn't work and produced an error. This is now fixed.
  A workaround was to not select the chartarea (click on the grey at the left/right to deselect it) and then do the export.
• Numbers » Convert "textnumbers" to numbers
  Fixed a bug that caused some number not being correctly converted to real numbers you could use for calculations. This bug was introduced in version 4.2.0 when we updated it to handle fractions better.
• Export » Export selection or active sheet as new file...
  Fixed the bug where the presented default file name displayed the name of the workbook reversed, such as 1kooB#Sheet1!B5_G26 instead of Book1#Sheet1!B5_G26.
  Improved the export in space-delimited format.
  Fixed the error in Excel 2007 when you choose to export the entire sheet.
• Export » Export selected chart or range as image (file)...
  When you exported a chart in EMF format the chart dimensions in the exported file could be changed into the initial height and width of the chart.
  This bug is now fixed and appeared in Excel 2000, XP/2002 and 2003 and only if you choose the EMF export format.
  This bug did not appear in Excel 2007.
  

  Example export with wrong dimensions:

  Example export how it should be and is in this version:

• Web » Activate hyperlinks (create from cell values)
  When you used the option not to change the font to the default hyperlink font(blue underlined), the cells were still underlined. In this version the underlinement will not change if you choose to keep the original cell formatting.
  Didn't work in shared workbooks. This is now fixed.
  This utility now uses the Excel =HYPERLINK() formula which is faster and much more flexible when it comes to large amounts of data then the previous technique which uses the right-click cell option to insert hyperlinks. We found out that Excel has an undocumented limit on the number of hyperlinks that are created that way.
• Format » Copy a sheet's page and print settings...
  When you only choose the option "Fit to pages", the fit to x pages wide by y pages tall options were copied but "Fit to" button was not selected. This is because that option is saved in Excel with the zoom-setting. The utility has now been changed so that the zoom option is automatically selected too when you check the "Fit to pages" option.
• Fill » List filenames in folder...
  Has been improved. It produced an error on shared workbooks if you selected the "Create hyperlinks to the files" option together with the option to create a new worksheet.
• Range » Copy formulas without changing their references
  Fixed the error when you copied the formulas to another worksheet.
• General
  Created a workaround to make ASAP Utilities work better when Excel 2007 is started by downloading a template via the Microsoft Office website.
• General
  Fixed a few small bugs.

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