Changes in version 5.0 - April 8, 2013

Finished

On April 8, 2013 the new version 5.0 is released. Download

Update: Version 4 and 5

Your current license will work with all 4.x ánd 5.x versions.
All existing 4.x customers will get 5.x free of charge. You can use the same license details.

New features and improvements

• Official support for Excel 2013 (32-bit edition of Excel 2013 on both 32- and 64-bit Windows)
  ASAP Utilities now works with:
  . Excel 2013 (32-bit version)
  . Excel 2010 (32-bit version)
  . Excel 2007
  . Excel 2003
  . Excel 2002/XP
  . Excel 2000
  . On both 32- and 64-bit Windows, including the new Windows 8.
  
• Range » Advanced sorting...
  Much faster
• Change not recognized numbers (text?) to numbers
  has been renamed to:
  Convert unrecognized numbers (text?) to numbers
• Favorites & Shortcuts » Organize your favorite tools...
  has been renamed to
  Favorites & Shortcuts » Edit your favorite tools and shortcut keys...
• Web » Clean information that is copied from websites...
  has been renamed to
  Web » Clean data and formatting...
  and this utility has also been placed in the Format, Text and Numbers & Dates submenus
  
• Select » Deselect cells...
  Much much faster when it involves entire rows or columns
• Select » Inverse selection...
  Much much faster when it involves entire rows or columns
• Export » Export selection or active sheet as new file...
  If you have Excel 2007 or newer you can now choose from:
  . Excel 97-2003 Workbook (*.xls)
  . Excel Workbook (*.xlsx)
  . Excel Binary Workbook (*.xlsb)
  (instead of just 'Excel workbook')
  
• Text » Start first word with Uppercase
  Instead of just making the first character uppercase, this utility now detects the first word by skipping other characters such as numbers and punctuation mark.
  For example a cell with the value "12 documents" will now be changed to "12 Documents" or "[document]" to "[Document]"
• Sheets » Split the selected range into multiple worksheets...
  Improved. It now uses the value of a cell as displayed (using the cell's number format)
• Formulas » Insert function from the ASAP Utilities library...
  Improved (calculation) speed for these functions.
• Export » Export worksheets as separate files...
  When choosing to export as Excel workbooks you can now also choose to export just the values.
  
• Columns & Rows » Conditional row and column select, hide or delete...
  Improved performance and progress info.
• Updated User Guide
  
• General, display
  The dialog boxes have all been verified and adjusted to scale properly if you have set your text display in Windows set to Medium - 125% or Large - 150%
  
• General
  Several improvements and a few spelling corrections.

Bug fixes

• Sheets » Freeze panes on multiple sheets at once
  In case a sheet had a Split then the freeze panes didn't work because a sheet cannot have both a Split and Freeze Panes.
  This is now fixed by first removing a Split and then applying the Freeze Panes
• Range » Advanced sorting...
  Now works correct on filtered data too.
• Columns & Rows » Detect and visualize adjacent data/group changes...
  Now works also if any of the cells in your selection contains an error.
• Export » Export worksheets as separate files...
  The option "Text (Delimited by semicolon ';') (*.txt)" didn't work in all international versions. If your system didn't have the semicolon specified as list separator in your Windows'  Region and Language settings, then this option didn't produce any files. This is now fixed.
  The option "do not export hidden cells" was ignored in Excel 2007 and later. This is now fixed.
• Fixed the bug that could cause Excel's "Show all windows in the Taskbar" setting to change.

• General
  Fixed the "Compile error in hidden module: MGlobals_Open" that appeared in a few rare occasions.
  A few small improvements.