New version for Excel 97: 3.10d, september 20, 2006

A new version of ASAP Utilties for Excel 97 has just been released. You can download version 3.10d, september 20, 2006 for Excel 97.

Major reasons for this release are serveral bugfixes.

This version is compatible with Excel 97 and all future versions. It does not require any special user-rights during the setup. If you have Excel 2000 or newer and you do have administrator or power user rights we recommend you to use the new version 4.0 also available from our website. That new version has some great new and improved utilities.

Bug fixes

• System » Rename current file
  If you specified a filename of a file that already existed that file was overwritten. ASAP Utilities will now ask you if you want to overwrite the existing file.
• Objects/Comments » Delete all objects from current sheet
  Remove objects handles form/VBA buttons better.
• Fill » Fill 'between values' linear in selection (vertical).
  Was swiched in the menu with the horizontal version.
  That is now corrected and horizontal fill now works too.
• Fill » Fill 'between values' linear in selection (vertical).
  Was swiched in the menu with the horizontal version.
  That is now corrected and horizontal fill now works too.
• Fill » Copy values to empty cells below filled cells in selection
  Resulted in an error when your selection included a cell in row number 1 and that cell was empty. This is now fixed.
• Range » Paste Special (with combinations)...
  Operations (like multiply) now function too
• General
  When you close Excel, and then chose "No", the ASAP Utilities menu was removed. This is now fixed. The ASAP Utilities menu will only be removed if you really close down Excel.
• System » Rename current file...
  When you use this tool to rename a template file (xlt) the renamed file was opened as a workbook based on the template. This is now corrected. The renamed template will be opened for editing.
• Text » Delete leading and trailing spaces
  Fixed the bug that could incorrectly convert dates. These cells are now skipped.
• Text » Delete leading and trailing and excessive spaces
  Fixed the bug that could incorrectly convert dates. These cells are now skipped.
• Select » Expand selection to last row
  Now supports multiple selected areas
• Select » Expand selection to last column
  Now supports multiple selected areas
• Select » Inverse selection
  Produced an error if you cancelled the selection of a cell.
• Numbers » Use a significant number of decimals
  Gave an error when you used it on cells without decimals.
  The speed of this utility is increased too.
• System » Clear recent files list in file menu
  Used to reset the amount of recent files back to Excel's default which is 4.
  This is now fixed and your setting will be kept.
• Objects » Select all objects on current sheet
  Gave an error if the sheet contained comments. A workaround has been made to make it work in that occasion too.