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.

Changes in version 4.7.2 - April 14, 2011

Published: April 14, 2011 (latest revision April 19, 2011)
reference id: QA0242


On April 14, 2011 the new version 4.7.2 is released. Download

New features and improvements

  • Sheets » Split the selected range into multiple worksheets...
    By request, the utility now also copies the row height.
  • Web » Activate hyperlinks (create from cell values)...
    Now automatically adds http:// in front of the hyperlinks if needed.
  • ASAP Utilities Options » New tools in development (English only)
    By request, the following tools are added:
    - Delete range names with bad cell references (#REF!)
    Removes all range names with invalid addresses. The utility creates a report that shows which names have been removed.
    - Ungroup all grouped columns in the selected worksheets
    - Ungroup all grouped rows in the selected worksheets
    - Bulk replace: replace multiple values at once
    You can specify a range with the values to search for and replace, which allows you to do many replacements automatically after each other. The target can be a certain range, your current worksheet, all selected worksheets, or even an entire workbook (that is open in Excel). At this moment the search/replace is done in cell values and hyperlinks. We're working on more items to search/replace in, such as formulas, comments, header/footer, textboxes, etc.
    We think this tool can be a huge time saver. Please let me know what you think of it and if we're missing something.
    Batch find and replace
    Replace mutiple items at once
  • System » Easily create a lot of folders based on the values in selected cells...
    Now supports creating subfolders if a cell value contains a value such as "folder\subfolder1\subfolder2".
    Previously the backslash \ in a cell value was changed to an underscore and then the folder was created. Now the backslash is used to create subfolders.
    Easily create a lot of folders and subfolders based on the values in selected cells
  • ASAP Utilities Options » Settings, language and contact information...
    Contains a new option: Help improve ASAP Utilities, Allow ASAP Utilities to report anonymous usage statistics. By default this option is turned on.
    These usage statistics don't include personal information, such as your name, company name or email address. Usage statistics do include the following information from your computer: Windows version and language, Excel version and language, ASAP Utilities version and language, and the id's of the 10 tools used most often.
    This information helps with the further development of ASAP Utilities and its documentation and translations.
  • General
    In the Windows Start menu, two existing options from ASAP Utilities have been renamed to a less technical sentence:
    "install ASAP Utilities as a default add-in in Excel" has been renamed to:
    "Add ASAP Utilities to the Excel menu"
    "uninstall ASAP Utilities as add-in in Excel" has been renamed to:
    "Remove ASAP Utilities from the Excel menu"
    ASAP Utilities in the Windows Start menu
  • Several small (speed) improvements.

Bug fixes

« back

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

Empowering Excel Users Worldwide for 25 Years