Softpedia >Windows >Office tools >Other Office Tools >ASAP Utilities Home & Student >  Changelog

ASAP Utilities Home & Student Changelog

What's new in ASAP Utilities Home & Student 8.6.0 RC 6

May 7, 2024
  • New/improved:
  • NEW: Numbers & Dates › 17. Date Picker...:
  • This date picker popup simplifies selecting and inserting dates into your spreadsheet.
  • It is handy for quickly finding and entering dates accurately, without errors in format or value.
  • The Date Picker pops up when double clicking on a cell with a date or a cell that is formatted as a date.
  • Via the settings button, or via 'ASAP Utilities Options › 1. Settings, language and contact information...' you can enable 'Show Date Picker Popup when double clicking on a date cell'.
  • The Date Picker popup Calendar will then show when you double click on a cell that either contains a date, or has the number format set to a date. It pops up a calendar where you can quickly browse by day, month, and year to choose a specific date. This calendar also displays (ISO) week numbers, making it easy to identify weeks. You can choose if the first day of the week starts on Monday, Sunday or Saturday. It lets you easily select a specific date by clicking on it, instead of having to type the date manually.
  • Once you select a date, it automatically inserts it into the selected cell. The Date Picker popup "floats", so you can easily keep it visible and select the cells where you want to insert a date. You can choose to automatically close the form after date entry, or move to the next cell (according to your personal "After pressing Enter, move selection Direction" in Excel's Advanced settings). If a cell isn't formatted as a date yet, it will apply the short-date format according to your regional Windows setting. To close the Date Picker popup, you can simply press the ESC-key or click the X in the title bar.
  • New: =ASAPCELLCOLOR(cell):
  • Returns the color number of the cell.
  • This is a number representing the RGB color value.
  • NEW: =ASAPFONTCOLOR(cell):
  • Returns the color number of the font of a cell.
  • This is a number representing the RGB color value.
  • General:
  • Fixed some known small issues and made a few small improvements.

New in ASAP Utilities Home & Student 8.6.0 RC 3 (Apr 25, 2024)

  • New/improved:
  • NEW: Numbers & Dates:
  • This date picker popup simplifies selecting and inserting dates into your spreadsheet.
  • It is handy for quickly finding and entering dates accurately, without errors in format or value.
  • It pops up a calendar where you can quickly browse by day, month, and year to choose a specific date. This calendar also displays (ISO) week numbers, making it easy to identify weeks. You can choose if the first day of the week starts on Monday, Sunday or Saturday. It lets you easily select a specific date by clicking on it, instead of having to type the date manually.
  • Once you select a date, it automatically inserts it into the selected cell. The Date Picker popup "floats", so you can easily keep it visible and select the cells where you want to insert a date. You can choose to automatically close the form after date entry, or move to the next cell (according to your personal "After pressing Enter, move selection Direction" in Excel's Advanced settings). If a cell isn't formatted as a date yet, it will apply the short-date format according to your regional Windows setting. To close the Date Picker popup, you can simply press the ESC-key or click the X in the title bar. Via the settings button, or via 'ASAP Utilities Options › 1. Settings, language and contact information...' you can enable 'Show Date Picker Popup when double clicking on a date cell'.
  • The Date Picker popup Calendar will then show when you double click on a cell that either contains a date, or has the number format set to a date.
  • New: =ASAPCELLCOLOR(cell):
  • Returns the color number of the cell.
  • This is a number representing the RGB color value.
  • NEW: =ASAPFONTCOLOR(cell):
  • Returns the color number of the font of a cell.
  • This is a number representing the RGB color value.
  • General:
  • Fixed some known small issues and made a few small improvements.

New in ASAP Utilities Home & Student 8.5.0 (Feb 29, 2024)

  • New/improved:Text › 7. Change Case (with options)...
  • Improved the "Set words to preserve/exclude" setting.
  • In addition to a space, it now also detects separate words based on any of the following characters: . ' ] ) ) { } : [ ( ; "
  • General:
  • Fixed some known small issues and made a few small improvements. Developed a fix for the issue where Excel sometimes stopped displaying the ASAP Utilities progress bar during processing.

New in ASAP Utilities Home & Student 8.4.0 (Jan 3, 2024)

  • New/improved:
  • Export in JSON format:
  • While Excel can import data in JSON format, it cannot natively save in this format.
  • Now, with ASAP Utilities, you can export to JSON.
  • JSON, or JavaScript Object Notation, is a lightweight format for storing and transporting data, often used in web applications for data exchange.
  • Saving your data in JSON-format has been added to the following tools:
  • Export › Export selection or active sheet as new file... Export › Export worksheets as separate files
  • Import data from copied Word Table without splitting cells at line breaks:
  • Via ASAP Utilities › ASAP Utilities Options › 11. New tools in development (English only)
  • When you copy a table from Word to Excel, Excel splits cells with line breaks into separate cells.
  • This tool helps you transfer your table to Excel while maintaining its original structure.
  • General:
  • Fixed some known issues and made a few small improvements.
  • Bug fixes:
  • Sheets › Reset Excel's last cell:
  • Fixed a bug that was introduced in version 8.3 where, if your dataset didn't begin in row 1 or column A, it could mistakenly delete one or more rows or columns of data at the end of your dataset.

New in ASAP Utilities Home & Student 8.3.0 (Nov 16, 2023)

  • Improved ribbon icons: They now appear clearer on high-resolution screens, especially when your Windows Display Scale is set above 200%.
  • Updated forms design: We've switched to a modern font, matching Excel's, to provide a smoother visual experience, a step up from the typical xlam add-in font.
  • Resolved issues and tweaks: We've fixed some known issues and made small but meaningful enhancements for a better overall experience.
  • Enhanded "View and manage hidden rows and columns...": The new layout shows more information at a glance, and a new horizontal scrollbar makes navigating wide row or column headers easier.

New in ASAP Utilities Home & Student 8.2.0 (Sep 7, 2023)

  • Here's what's new:
  • Improved User Experience: We've addressed some known issues and introduced numerous small but impactful enhancements. This ensures a smoother and more efficient experience for all your Excel tasks. No More API Calls in Localized Ribbons/Menus: For our users who've faced challenges with API calls from Office macros, we have good news. Our localized per language ribbon/menu xlam-files no longer make any API calls. This update is crucial for some of our clients.

New in ASAP Utilities Home & Student 8.1.0 (Feb 14, 2023)

  • New/improved:
  • Range › 4. Sort values inside each cell in selection...
  • By request, we have added an option to sort in reverse order.
  • You can then for example sort first by state and then by city for a cell that includes "City, State".
  • Sort inside cells in reverse order
  • General:
  • A few visual improvements.
  • Bug fixes:
  • Autofit row height (also on merged cells)
  • Improved when working with a merged area that contains many rows and a large amount of text.
  • Merge and/or import multiple files...
  • Fixed a bug where a combination of an empty first row and formulas with references to another sheet and possible sheet protection could cause a shift in values.
  • General
  • Fixed some other known issues.

New in ASAP Utilities Home & Student 7.9.4 (Apr 13, 2022)

  • Several small improvements and a few small bug fixes.

New in ASAP Utilities Home & Student 7.4 (Mar 3, 2018)

  • Both editions:
  • General:
  • Several small improvements.
  • Export » Export selection or active sheet as new file...:
  • Export to CSV Unicode, newline character added at the end of the file.
  • Better preserving of the Pivot Table formatting when exporting as values.
  • Export » Export worksheets as separate files...:
  • Better preserving of the Pivot Table formatting when exporting as values.
  • Numbers & Dates » Convert/recognize dates...:
  • Improved speed
  • Columns & Rows » Delete all empty rows:
  • Now handles large Tables better.
  • Functions =ASAPSUMBYCELLCOLOR() and =ASAPSUMBYFONTCOLOR():
  • Cells with logical values (TRUE/FALSE) are now ignored, and cells with a date value are now included too, so that you can also sum dates based on the cell's interior or font color.
  • "32+64-bit edition" only:
  • Improved startup speed.
  • German language: fixed the spelling in the spell number functions (füftausendzwölf / f~nftausendzwxlf)
  • Workaround/fixed the small xlb file size increase caused by a bug in Excel when then right-click menu in ASAP Utilities was enabled.

New in ASAP Utilities Home & Student 7.3.1 (Jul 4, 2017)

  • Non-admin setup version available of the Business edition
  • For users with Excel 2010, 2013 or 2016/365 we have created a special version of the setup that standard/limited users can install.
  • This single-user setup does not require administrator rights during the installation.
  • Undo
  • Improved performance with complex workbooks.
  • General
  • Several small improvements.
  • Minor text fixes.
  • Support for running the setup via the SYSTEM account.

New in ASAP Utilities Home & Student 7.0 (May 31, 2016)

  • General:
  • Several improvements compared to ASAP Utilities 5.6
  • Bug fixes:
  • A few small bug fixes

New in ASAP Utilities Home & Student 5.6 (May 31, 2016)

  • Improved:
  • Export » Export selection as HTML table to clipboard...
  • Export » Export worksheets as separate files...
  • NEW: Text » Subscript the numbers in Chemical Formulas
  • Export » Export selection or active sheet as new file...
  • Improved: Import » Insert (delimited) text file...
  • Select » Select cells based on content, formatting and more...
  • NEW: Convert long HEX values to ASCII text in selected cells
  • Improved: Favorites & Shortcut keys » Edit your favorite tools and shortcut keys...
  • Improved: Import » Merge and/or import multiple files...
  • Bug fixes:
  • Information » Count duplicates and give each set of duplicates its own color
  • Formulas » Change formula reference style (e.g. A1 to $A1 etc.)...
  • File & System » Find and remove external links...
  • Improved compatibility with Excel 2013/2016
  • Startup, right-click menu

New in ASAP Utilities Home & Student 5.5 (May 31, 2016)

  • NEW: Range > Sort values inside each cell in selection...
  • NEW: Information > Count duplicates and give each set of duplicates its own color
  • NEW: > Text > Change Case (with options)...
  • NEW: Range > Copy selection and paste into only the visible cells...
  • NEW: Format > Replace conditional formatting with static formatting in selection
  • Improved: Export > Export worksheets as separate files...
  • Improved: Text > Convert/recognize dates...
  • Improved: File & System > Find and remove external links...
  • Improved: Export > Export selected chart or range as image (file)...
  • Improved: Sheets > Split the selected range into multiple worksheets...
  • Improved: Favorites & Shortcut keys > Edit your favorite tools and shortcut keys...
  • Improved: function =ASAPSHEETNAME(optional reference)
  • Improved: Columns & Rows > Autofit row height (also on merged cells)
  • Improved: Range > Find and/or replace in all sheets...
  • Improved: Bulk replace: replace multiple values at once
  • NEW: Detect adjacent row/column data and merge cells...
  • New: Keep or delete certain Rich Text formatted characters...
  • New: Text to Columns based on in-cell formatting changes (split by bold, italic, color etc.)
  • NEW: Change cells to MAC Address formatting...
  • Bug fixes:
  • Information > Create a list of filenames and properties in a folder...
  • Improved handling of folder names that are longer than 255 characters.
  • Sheets > Delete unused empty ending rows/columns
  • Workaround for the error that occurred when the ending empty columns or rows were part of a pivot table.
  • Sheets > Reset Excel's last cell
  • Workaround for the error that occurred when after the last cell there were still empty columns and/or rows that were part of a pivot table.
  • Columns & Rows > Delete all empty columns
  • Returned an error when a pivot table contained empty columns because these could not be removed. These columns are now skipped.
  • Columns & Rows > Delete all empty rows
  • Returned an error when a pivot table contained empty row because these could not be removed. These rows are now skipped.
  • Columns & Rows > Delete all hidden rows and/or columns...
  • Returned an error when a pivot table contained hidden rows and/or columns because these could not be removed. These rows and/or columns are now skipped.
  • Text > Convert/recognize dates...
  • Now skips cells that contain only one or more space characters.
  • Select > Select cells based on content, formatting and more...
  • Improved the notification when no results were found or all selected cells match your criteria. Also improved preserving the initial selection when selecting values or formulas and no results were found.
  • Favorites & Shortcut keys > Edit your favorite tools and shortcut keys...
  • Your changes were not shown until you restarted Excel. This is now fixed. After closing the tool, you'll immediately see the changes in your "Favorites & Shortcut keys" menu again.
  • Select > Select cells based on content, formatting and more...
  • The options "contains" and "does not contain" were not case sensitive if you choose the option "Match Case". This is now fixed.
  • General
  • A few small bug fixes and improvements.

New in ASAP Utilities Home & Student 5.2.1 (May 31, 2016)

  • Sheets > Split the selected range into multiple worksheets:
  • Fixed a bug that was introduced in version 5.2 and caused the following option to not work correct: 'For every new value/group in column'.

New in ASAP Utilities Home & Student 5.2 (May 31, 2016)

  • Format » Detect and visualize adjacent data/group changes:
  • New: You can now specify the line color for the border.
  • And you can choose to remove any existing horizontal borders upfront.
  • Bug fixes:
  • Only applies if you use Excel 2007, 2010 or 2013 that is not English, Spanish, French, German or Dutch: Fixed the following error that appeared for some users after they installed version 5.1:
  • Sorry, ASAP Utilities cannot be started.
  • The file '' doesn't seem to exist.
  • Please reinstall ASAP Utilities (or make sure the xlam file exists in the subfolder \resources\).

New in ASAP Utilities Home & Student 5.1 (May 31, 2016)

  • New features and improvements:
  • Range > Advanced sorting: We've added a new sort option: "Value, ignore minus sign (-) in numbers"
  • Range > Advanced sorting: We've added a new sort option: "Reverse order"
  • NEW: Count and color unique duplicate values via ASAP Utilities Options > New tools in development (English only)
  • NEW: Insert a space before Capital Letters (e.g. 'BigBearLake' > 'Big Bear Lake') via ASAP Utilities Options > New tools in development (English only)
  • Import > Merge and/or import multiple files: New option to choose if the data should be copied/pasted as 'values' or 'formulas'.
  • Text > Replace accented characters (á, ë, ñ etc.): Greek accented characters have been added.
  • Web > Decode all URL and HTML encoded text: Now also supports (all) Unicode characters (except when you run Excel in Windows 2000).
  • Setup, Trusted Publishers: During the setup you can now have our company (A Must in Every Office BV) automatically added to the List of Trusted Publishers in Excel
  • Customization, add tools to the Ribbon: The tools from ASAP Utilities are now easier to add to the QAT (Quick Access Toolbar) from Excel 2013/2010/2007
  • General: A few small improvements and a few spelling corrections.
  • Bug fixes and improvement:
  • Export > Export worksheets as separate files: The combination of a filtered table and excluding hidden rows/columns from the export could result in an error. This is now fixed.
  • Sheets > Change name of selected sheets to selected cell's value: Didn't work if the specified cell on the sheet was hidden. This is now fixed.
  • Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error were skipped. Such formulas are now updated too.
  • Range > Find and/or replace in all sheets: The combination of "Find/replace in: Range" and "Look in: Formulas", didn't replace anything. This is now fixed.
  • Formulas > Change formula reference style (e.g. A1 to $A1 etc.): Formulas that referenced to a cell with an error or resulted in an error were skipped. These formulas are now updated too.
  • Copy to clipboard in Windows 8 x64: Due to a bug in the Windows 8 64-bit edition (only this edition), copying to the clipboard didn't work.
  • Information > Report the formulas used in the worksheets in your workbook: If you had a formula with a large number which was formatted as a date, then this could result in an "overflow" error. This is now fixed.
  • Web > Remove all HTML tags in the selected cells: Any text after the % character was decoded or removed. This is now fixed so that it only gets decoded and for example SQL statements that use % are now preserved.
  • Fill > Insert current date and time with seconds: The applied number format now shows the seconds too.
  • Text > Delete leading and trailing spaces: If a zero (0) was left as the result in a cell, then it was entered as "text". This is now corrected so that it is entered as a number.
  • Range > Fill cells with their formatted value is now also listed in the Numbers & Dates submenu: Numbers & Dates » Fill cells with their formatted value
  • Information > Fast calculation on selected cells: If you choose to "Create a workbook with these results" then the calculation results of the "Unique values" and "Values that appear only once" were switched.
  • Import > Merge and/or import multiple files: Speed improvement. In version 5.0 copying/preserving the row height on import was added, but it was slow for files with many rows. This is now fixed.
  • Columns & Rows > The paper saver (split columns): Didn't remember your last used settings. This is now fixed.
  • Language: The English term "wildcards" in the tools, has been replaced with the text "wildcard characters".
  • Speed improvement for editing data in Tables in Excel 2010 and Excel 2013: In Excel 2010/2013 some tools that edited data in a defined Table (a Table as via "Home > Format as Table" or "Insert > Table") on a worksheet with many formulas didn't run at the usual speed (sometimes it was even painfully slow). The speed difference could be huge compared to earlier Excel versions and compared to editing the same data when it was not in a defined Table*.
  • General: A few small bug fixes and improvements. When Excel 2013, 2010 or 2007 is doing something in the background and the running tool from ASAP Utilities has to wait for this, then this message is shown in the status bar "Waiting for response from Excel...".

New in ASAP Utilities Home & Student 5.0 (May 31, 2016)

  • 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.
  • 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.
  • General
  • Fixed the "Compile error in hidden module: MGlobals_Open" that appeared in a few rare occasions.
  • A few small improvements.

New in ASAP Utilities Home & Student 4.8.6 (Oct 9, 2012)

  • New features and improvements:
  • General
  • A few small improvements and spelling corrections.
  • Formulas » Report the formulas used in the worksheets in your workbook
  • Fixed the bug that could prevent the report from being created in case there were (very) long text values. This is now fixed.

New in ASAP Utilities Home & Student 4.8.5 (Oct 9, 2012)

  • New features and improvements:
  • Select » Select cells based on content, formatting and more...
  • Massive speed improvement due to a new developed algorithm.
  • Massive speed improvement due to a new developed algorithm.
  • NEW: Range » Paste values only
  • This will paste the copied data as values only.
  • You can assign your own shortcut to this via the "Favorites & Shortcuts" menu, such as for example Control+Shift+V.
  • This tool can speed things up when you use this often and save you a few strokes/mouse actions compared to the "Edit > Paste special > Values" via the menu in Excel when you assign a shortcut to it.
  • Paste values only (replace formulas with their calculated results)
  • Objects & Comments » Add cell's value or formula to comment...
  • This tool add's the cell's value or formula as comment.
  • You can choose to add new comments, replace existing comments or add the cell's value at the beginning or the end of an existing comment.
  • You can use to use the cell's value or formula as text for the comment.
  • By using "Offset" you can specify to read the value of the current cell or a cell to the left or right from it.
  • Add cell's value or formula to comment...
  • Formulas » Correct the link to the ASAP Utilities worksheet functions
  • This tool can be used to correct the reference in your workbook to the ASAP Utilities worksheet functions.
  • This can be useful if your workbook is used on another computer where ASAP Utilities is installed in a
  • different folderFor example the default installation folder of ASAP Utilities differs between a 32-bit and 64-bit Windows version.
  • Formulas » Insert an apostrophe (') in front of each formula in the selected cells
  • This tool inserts an apostrophe (') in front of each formula in the selected cells, which turns them to text.
  • Note:
  • To turn the changed formulas to actual formulas again, you can use the following tool from ASAP Utilities "Numbers » Change not recognized numbers (text?) to numbers"
  • Formulas » Report the formulas used in the worksheets in your workbook
  • This tool will report with all formulas used in the worksheets on your workbook.
  • The report shows the following information:
  • Workbook path and name
  • Sheet; The name of the worksheet the formula is on
  • Cell; The cell address the formula is inYou can click on the address to jump to it, it is a hyperlink.
  • Value; The calculated result
  • Displayed value; The displayed result
  • Formula; The formula
  • Report the formulas used in the worksheets in your workbook
  • Range » Delete all range names with an invalid cell reference (#REF!)
  • This tool removes all range names that have an invalid reference (#REF!).
  • A report with the results will be presented to you.
  • Web » Remove all HTML tags in the selected cells...
  • This tool will strip all html tags in the selected cells, such as for example , , , , etc..
  • You can choose to:
  • Keep existing line breaks
  • Add line breaks at the end of tags such as , , etc..
  • In addition it will also convert encoded characters such as   and & to normal characters.
  • Remove/replace all HTML tags in the selected cells...
  • IMPROVED: Fill » Create a list of filenames and properties in a folder...
  • You can now choose to include many additional file details to display, just like in Windows Explorer.
  • This way you can for example include the album and artist information from your music collection or information from your photos such as width and height, ISO speed ratings, F-stop, etcetc.
  • The available fields depend on your Windows versionASAP Utilities relies on Windows for the details to display.
  • Display file details in Excel
  • Example with detailed information from music files:
  • Music (MP3) album and artist info in Excel
  • Export » Export worksheets as separate files...
  • Your workbook's color palette/color-scheme is now copied too in case of an Excel export.
  • Export » Export selection or active sheet as new file...
  • Your workbook's color palette/color-scheme is now copied too in case of an Excel export.
  • Sheets » Change name of selected sheets to selected cell's value
  • The cell's displayed value is now usedFor example if you have a date, 12/14/2012 displayed as Dec 14, the value "Dec 14" will be used instead of the numerical date.
  • Sheets » Insert multiple sheets (uses the cell values as sheet names)...
  • A cell's displayed value is now usedFor example if you have a date, 12/14/2012 displayed as Dec 14, the value "Dec 14" will be used instead of the numerical date.
  • System » Save file and create backup
  • You can now choose to create a backup copy in either your backup folder, or in the same folder as your workbook.
  • Save file and create backup in backup folder or current file's folder
  • NEW: Transform table into 3 column matrix (reverse pivot table)
  • via ASAP Utilities Options » New tools in development (English only)
  • Transform a table into a 3 column table that you can easily use as a source for for example a pivot table.
  • Export » Export selection or active sheet as new file...
  • When creating text-files, this tool now uses your current workbook settings for the decimal- and thousand separator in the outputUnless you choose specific settings on the formPreviously Excel's default VBA (US international) settings were used.
  • Export » Export worksheets as separate files...
  • When creating text-files, this tool now uses your current workbook settings for the decimal- and thousand separator in the outputUnless you choose specific settings on the formPreviously Excel's default VBA (US international) settings were used.
  • Numbers » Move minus sign from back to front (e.g65- to -65)
  • Added automatic detection and removal of leading or trailing spaces.
  • Export » Export worksheets as separate files...
  • Added new export formats:
  • Web Page (*.htm, *.html)
  • Single File Web Page (*.mht, *.mhtml) (only with Excel 2002/XP, 2003, 2007 and 2010)
  • PDF (*.pdf) (only with Excel 2010 and Excel 2007 SP2 or Excel 2007 SP1 with the MS PDF plugin installed)
  • Export sheets as PDF or HTML documents
  • New worksheet functions:
  • =ASAPFILEPROPERTIES(property_name_or_id)
  • Returns the value of one of the built-in document properties for the current workbook.
  • You can refer to document properties either by index value or by their English name.
  • The following list shows the available built-in document property names:
  • 1 Title
  • 2 Subject
  • 3 Author
  • 4 Keywords
  • 5 Comments
  • 6 Template
  • 7 Last Author
  • 8 Revision Number
  • 9 Application Name
  • 10 Last Print Date
  • 11 Creation Date
  • 12 Last Save Time
  • 13 Total Editing Time *
  • 14 Number of Pages *
  • 15 Number of Words *
  • 16 Number of Characters *
  • 17 Security
  • 18 Category
  • 19 Format
  • 20 Manager
  • 21 Company
  • 22 Number of Bytes *
  • 23 Number of Lines *
  • 24 Number of Paragraphs *
  • 25 Number of Slides *
  • 26 Number of Notes *
  • 27 Number of Hidden Slides *
  • 28 Number of Multimedia Clips *
  • 29 Hyperlink Base
  • 30 Number of Characters (with spaces) *
  • Excel isn't required to define values for every built-in document property.
  • If Microsoft Excel doesn't define a value for one of the built-in document properties, reading the Value property for that document property results in an error.
  • =ASAPFILEPROPERTIES() function
  • =ASAPLOADIMAGE(image_fullname, optional width_in_pixels, optional height_in_pixels)
  • Inserts the specified image as an object and puts it at the left-top of your cell.
  • To update the image, you can replace the formula with a new image name.
  • To remove the image you have to remove both the formula and the image(The image isn't removed if only the formula is removed.)
  • Example:
  • =ASAPLOADIMAGE("D:productsimagesart782.gif")
  • Parameters:
  • image_fullname = The full path and file name of an image of the type that Excel supports
  • width_in_pixels = OptionalYou can specify the width pixelsIf omitted, the width will be proportionally based on the image's height
  • height_in_pixels = OptionalYou can specify the height in pixelsIf omitted, the height will be the height of the cell the formula is in.
  • =ASAPLOADIMAGE() function
  • Fill » Insert before and/or after each cell in your selection...
  • Added support to use the {tab} or {lf} codes to insert either a tab or line feed (alt+enter) character.
  • Text » Replace accented characters (á, ë, ñ etc.)...
  • Several characters are added.
  • If you've used this utility before then you may have to press the "Reset" button in order to see these new characters added.
  • Replace accented characters
  • Export » Export selection as HTML table to clipboard...
  • The links in =HYPERLINK() formulas are now used too.
  • Links entered as text or a reference to a cell is supported such as for example
  • =HYPERLINK("http://www.asap-utilities.com", "ASAP site") or =HYPERLINK(A1, "ASAP site")
  • Web » Extract hyperlinks...
  • The links in =HYPERLINK() formulas are now used too.
  • Links entered as text or a reference to a cell is supported such as for example
  • =HYPERLINK("http://www.asap-utilities.com", "ASAP site") or =HYPERLINK(A1, "ASAP site")
  • Columns & Rows » Merge column data (join cells)...
  • Improved speed
  • Undo
  • New performance setting:
  • To speed things up you can now choose to disable the undo when your action involves a filtered list and more than a specified amount or rowsBy default this option is turned on and the undo will only be available in a filtered list when your sheet involves less than 25000 rows.
  • New performance setting: You can now choose to disable the undo when your action involves a filtered list and more then a specified amount or rows
  • Alert me if the operation continues without undo
  • General
  • A few small improvements.
  • Bug fixes:
  • Numbers » Spell/write out numbers or amounts (EN, DE, NL)...
  • and =ASAPSPELLNUMBER()
  • Fixed the bug that caused negative numbers less than -10 to be spelled out incorrect;
  • The text 'Hundred' was incorrectly added every timeFor example -10,00 was incorrectly listed as minus Hundred Ten Dollars and No Cents.
  • This only affected negative numbers less than -10 and it is fixed now.
  • Furthermore, if a number as more than two decimals, this tool will now round it to two, instead of just using the first two numbers after the decimal characterFor example 12.557 is now rounded to 12.56Previously it was 'cut' to 12.55.
  • Import » Merge and/or import multiple files...
  • If the imported file started with one or more empty lines and you choose to start the import not on row 1, then the last data-row was incorrectly determined and not all rows were importedThe tool assumed your file always had data on row/line 1.
  • This is now fixed.
  • Objects & Comments » Comment tools...
  • Extract/report content of comments > Place the value of the comment cell right next
  • to the comment
  • This part of the tool didn't work on merged cellsIf a merged cell with a comment existed within your selection, it "tripped" and you got the error.
  • This is now fixed.
  • Undo
  • Fixed the following error that could sometimes appear when running a tool on a filtered list:
  • "Sorry, something went wrong when preparing the undo
  • Error 1004: PasteSpecial method of Range class failed"
  • Range » Find and/or replace in all sheets...
  • Didn't find/recognize formulas in the non-English notationWe used Excel's Range.Find() and Range.Replace() method but that has the limitation of only using the English notation for formulasWe've fixed this by using a workaround.
  • Export » Export worksheets as separate files...
  • The "Do not export hidden cells" didn't work for text-file outputThis is now fixed.
  • In some situations in combination with Excel 2007 and 2010 the exported Excel sheets could end up being in "manual calculation" modeThis is now fixed.
  • ASAP Utilities worksheet functions
  • If you have multiple workbooks open with one of these functions then they always return the name of the active workbook, which gives incorrect results for the open workbooks in the backgroundIt went wrong with the following functions:
  • =ASAPFILENAME()
  • =ASAPFILEPATH()
  • =ASAPFULLFILENAME()
  • =ASAPFILEPROPERTIES()
  • This is now fixed.

New in ASAP Utilities Home & Student 4.8.0 (Oct 9, 2012)

  • New features and improvements:
  • Filters and AutoFilters: Mimic Excel's behavior
  • Excel skips certain operations on hidden cells (cells in hidden rows or columns) if your worksheet contains filtered data (a Filter or AutoFilter)For example if you select range A1:A10 and rows 2 till 9 are hidden and you apply a color, then the color is only applied to the visible cells (A1 and A10).
  • However, Excel only skips these cells if your worksheet has and autofilter, otherwise the color is applied to both the visible and the hidden cells.
  • ASAP Utilities now mimics that behaviorIf your worksheet contains a Filter or AutoFilter and your selection contains hidden cells, then these hidden cells are skipped by the following tools:
  • Filtered DataActivate hyperlinks (create from cell values)...
  • Advanced character remove or replace...
  • Apply standard format to selected cells
  • Change formula reference style (e.gA1 to $A1 etc.)...
  • Change negative numbers to positive and vice versa...
  • Change not recognized numbers (text?) to numbers
  • Change to lowercase
  • Change to UPPERcase
  • Change values to text values (adding ' in front)
  • Convert percentages to numbers (e.g5% to 5)
  • Convert/recognize dates...
  • Copy values to empty cells below filled cells in selection
  • Decode all URL and HTML encoded text
  • Delete all after a given number of characters...
  • Delete all numbers in selection
  • Delete all text characters (a-z) in selected cells
  • Delete leading and trailing spaces
  • Delete leading, trailing and excessive spaces
  • Delete number of ending characters...
  • Delete number of leading characters...
  • Extract hyperlinks...
  • Fill cells with their formatted value
  • Fill empty cells in selection...
  • Fill up with leading zeros...
  • Make first character Uppercase, the rest lowercase
  • Make last character subscript
  • Make last character superscript
  • Move minus sign from back to front (e.g65- to -65)
  • Overwrite filled cells in selection...
  • Quick numbering of selected cells...
  • Rebuild array formulas
  • Remove all hyperlinks in selected cells
  • Remove ending carriage return (alt+enter character)
  • Replace accented characters (á, ë, ñ etc.)...
  • Reverse text in selected cells
  • Round numbers (not formatting, but changing)...
  • Spell/write out numbers or amounts (EN, DE, NL)...
  • Start Each Word With Uppercase
  • Start first word with Uppercase
  • Unwrap text
  • Use a significant number of decimals...
  • Wrap text
  • New: Add cell's value or formula to comment
  • New: Change text case (with options)
  • New: Change julian dates to normal dates in selected cells
  • New: Subscript the numbers in chemical equations
  • New: Change conditional formatting to static formatting
  • For your information, in previous versions of ASAP Utilities, you had to first use Excel to selected only the visible cells in your selection as a workaround (Excel, F5 > Special..> Visible cells only) if you only wanted the tools to affect the visible cells in your selected range.
  • ASAP Utilities Options » New tools in development (English only)
  • The following tools are added by request:
  • Change conditional formatting to static formatting
  • This tool will change the conditional formatting in selected cells to static formatting.
  • It verifies the formatting that has been applied via conditional formatting (font, color and borders) and then apply that as standard formatting.
  • Settings of font, color and borders will be appliedData Bars and Icon Sets cannot be made static with this tool.
  • This tool only works with Excel 2000, 2000/XP, 2003 and 2010 (Excel 2007 is not supported).
  • Don't hesitate to experiment with this tool, it has and undo.
  • A practical example on when this can be useful:
  • 'We work a lot with conditional formatting (in Excel 2003), but our client wants us to “freeze” the format (Yes, that means no more “conditional”...) in order to have a classical Excel format (mainly cell and font colours).
  • The idea is to do the same thing as we do with formulas or calculations "copy/paste in value" but for conditional formatting.'
  • Change conditional formatting to static formatting in selected cells
  • ASAP Utilities Options » New tools in development (English only)
  • The following tools are added by request:
  • Add cell's value or formula to comment
  • Add the value formula as commentYou can choose replace existing comments or add the value at the beginning of the end of an existing comment.
  • You can also specify to read the value of a cell to the left or right and use that value or formula as comment.
  • Don't hesitate to experiment with this tool, it has an undo.
  • Add cell's value or formula to comment
  • Insert an apostrophe (') in front of each formula in your selection
  • ASAP Utilities Options » New tools in development (English only)
  • Change julian dates to normal dates in selected cells
  • This tool has been updated so that besides the yyddd and yyyyddd now the JD Edwards (AS/400) cyyddd format is also supportedTheir system adds a 0 or 1 in front of the year representing the century (0 = 1900, 1 = 2000, Jan 15, 1910 is 010015, Jan 15, 2010 is 110015).
  • Export » Copy selection as values to clipboard
  • Skipped the confirmation at the end "The data has been copied to the clipboard"This was removed by request from users who used this utility a lot.
  • Import » Merge and/or import multiple files...
  • New, when you merge the data you can now choose to have the filename listed in column A.
  • Merge files
  • Columns & Rows » Delete all hidden rows and columns
  • This utility used to delete all hidden rows and columns together.
  • You can now choose to either delete all hidden rows, all hidden columns or both.
  • Between brackets the tool shows how many rows and columns are hidden on your worksheet:
  • Delete all hidden rows and/or columns
  • Export » Export worksheets as separate files...
  • Has a new option to choose; "Do not export hidden cells", just like the utility
  • "Export selection or active sheet as new file..."
  • Export worksheets as separate files: Do not export hidden cells
  • We also added the Excel Binary7 Workbook-format (xlsb) if you have Excel 2007 or newer:
  • Save worksheets as separate files in the Excel Binary Format (for Excel 2007 and 2010)
  • General
  • A few small improvements
  • Bug fixes:
  • ASAP Utilities » Columns & Rows » Drawing paper
  • With French regional settings in Windows this tool gave an errorThis is now fixed.
  • In Excel 2007 and 2010 when you had selected the entire sheet and started this utility it raised an errorThat is now fixed.
  • Sheets » Freeze panes on multiple sheets at once
  • When you have only selected one single sheet, ASAP Utilities selects them all for you, but that gives an error if you have any hidden sheets in your workbookThis is now fixed by automatically selecting only the visible sheets.
  • Web » Activate hyperlinks (create from cell values)...
  • In version 4.7.2 we have updated this tool so that it automatically adds http:// in front of hyperlinks if neededHowever if you link to a file and the link doesn't start with a drive or folder letter, it is treated by the tool as an internet hyperlink and http:// is automatically placed in front of it.
  • We've have now updated the tool by using a better detection for internet hyperlinks.
  • Format » Detect and visualize adjacent data/group changes...
  • Didn't work if your selection contained cells with an errorThis is now fixed.
  • Range » Count and/or color duplicates in selection...
  • Could produce an error if you had selected multiple non-adjacent columnsThis is now fixed.
  • Columns & Rows » Put together rows or columns from several sheets...
  • Fixed the bug that caused your chosen range to expand if your given columns or rows included merged cells.
  • Select » Select cells based on content, formatting and more...
  • "When using "Select cells based on content, formatting and more..." and finding no cells matching the search criteria, I expect no cells to be selected.
  • But in fact all cells from A1 to End-of-Sheet are selected!"
  • If you have a single cell selected and then start the utility, the tool then assumes that you want to search in the entire workbook and pre-selects thatHowever, if no matching cells are found the entire sheet was still selectedThis is now fixed.
  • Sheets » Split the selected range into multiple worksheets...
  • Fixed the following bug:
  • "When I use the tool Sheets->Split the selected range into multiple worksheets to split selection by number of rows (option: For every so many rows) and my selection doesn’t start in the first row of the sheet there is an error:
  • The first newly created worksheet doesn’t contain the first couple of selected rows (depending on how far the selection is from the top of the sheet).
  • For example, if I want to split range A3:A12 (10 rows) into two sheets with 5 rows each, the first two rows are lost."
  • Export » Export selection or active sheet as new file...
  • Fixed the bug that caused the export to the clipboard as TAB delimited to be empty.
  • Export » Export worksheets as separate files...
  • Fixed the bug that could sometimes appear with very large files:
  • "Sorry, something unexpected went wrong at code line 800: Error 6: Overflow".
  • Undo
  • Fixed two bugs that we found (but so far have never been reported).
  • Improved reliability for the undo when your worksheet/selection was filtered.
  • If the worksheet contained an autofilter and frozen panes then the freeze pane settings could become altered in some cases due to an Excel bugThis is now fixed.

New in ASAP Utilities Home & Student 4.7.2 (Oct 9, 2012)

  • 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:
  • Export » Export selection or active sheet as new file...
  • The option "Copy to clipboard (tab delimited)" always included hidden cells, even if the option "Do not export hidden cells" was checked. This is now fixed.
  • The tab-export options used the TSV (Tab Separated Value) file extension name. The TXT extension is now added too, but tsv is still the default.
  • Columns & Rows » Put together rows or columns from several sheets...
  • Now accepts a column/row address in R1C1 notation too.
  • Sheets » Split the selected range into multiple worksheets...
  • If the data didn't start in column A, then the headers were'nt copied along correctly. This is now corrected.
  • Export » Export worksheets as separate files...
  • The option "As displayed" didn't work in combination with delimited text files. This is now fixed.
  • A few small bug fixes.

New in ASAP Utilities Home & Student 4.7.1 (Oct 9, 2012)

  • New features and improvements:
  • Example workbook for the extra worksheet functions that you get with ASAP Utilities.
  • We have created a example workbook that shows how to get things done, that are normally not possible in Excel, by using the functions that ASAP Utilities adds.
  • Download "Example-workbook-ASAP-Utilities-formulas.xls".
  • Worksheet functions added by ASAP Utilities
  • Calculate the sum of cells with a certain color
  • Get the text from a cell's comment into a cell
  • Columns & Rows » Conditional row and column select, hide or delete...
  • Improved speed, especially when it comes to deleting rows or columns.
  • Sheets » Protect multiple sheets at once...
  • This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
  • If you unshare the workbook then you can use this utility.
  • Sheets » Unprotect multiple sheets at once...
  • This utility doesn't work on shared workbooks. Instead of giving an error this tool will now tells you that upfront.
  • If you unshare the workbook then you can use this utility.
  • Favorites & Shortcuts » Organize your favorite tools...
  • New option: Create a list of all shortcuts
  • This allows you to print out a quick reference card/cheat sheet of your favorite tools and the assigned shortcuts that are used by ASAP Utilities.
  • Cheat sheet - A list of all shortcuts uses by ASAP Utilities
  • Format » Detect and visualize adjacent data/group changes...
  • You can now specify the number of empty rows to insert in between.
  • Insert empty rows between groups of the same data
  • Insert empty rows between groups of the same data
  • NEW: Correct the link to the ASAP Utilities worksheet functions in your workbook
  • via: ASAP Utilities Options » New tools in development (English only)
  • When you use a function from ASAP Utilities in your workbook and the workbook is opened by someone who has install ASAP Utilities in a different folder, then these formulas might give an error (#NAME?) because ASAP Utilities can't be found. If you get such a workbook and you run this utility, it will be corrected.
  • NEW: Change text case (with options)
  • via: ASAP Utilities Options » New tools in development (English only)
  • In addition to the existing change-case tools, this utility allows exceptions, such as certain abbreviations.
  • Change text case (with options)
  • Text » Convert/recognize dates...
  • The utility now also automatically recognizes time values at the end of the value. It does this automatically if the time is written in any of the following formats hh:mm:ss, h:mm:ss, hh:mm:ss AM/PM or h:mm:ss AM/PM. The utility also recognizes hh:mm:ss.000 and h:mm:ss.000 but in that case the milliseconds are stripped off.
  • General
  • Improved installer.
  • A few minor improvements.
  • Bug fixes:
  • =ASAPGETDOMAIN()
  • If you specified to show the protocol too, the utility incorrectly showed https for ftp and ftps. This is now corrected.
  • =ASAPSUMBYFONTCOLOR()
  • If you specified a cell to read the font color from, the function incorrectly used the cell color instead of the font color. This is now corrected.
  • Shortcuts
  • If you changed the shortcuts used by ASAP Utilities then previously assigned shortcuts weren't released until you restarted Excel. That is now fixed.
  • Select » Select cells based on content, formatting and more...
  • Due to a limitation of Excel's Range.Address method in combination with a method we used you could sometimes get the message "No (new) results were found. Your selection didn't change.", even though the numeric value you searched for was there. This is now fixed.
  • File size Toolbar
  • via ASAP Utilities Options » Settings, language and contact information...
  • In version 4.6.4 an unfortunate bug was introduced which caused this utility to not work. This is now fixed.

New in ASAP Utilities Home & Student 4.6.4 (Oct 9, 2012)

  • New features and improvements
  • Find and run a utility...
  • You can quickly add the tool from within the result window to your Favorites-menu by pressing the + button:
  • Quickly add the tool found to your favorites menu
  • NEW: Sheets » Split the selected range into multiple worksheets...
  • With this tool you can quickly split your data into multiple sheets.
  • You can do this either by value, for example to create a new sheet for each company, or you can specify the number of rows to create per sheet.
  • We have also received the request for this tool from people that used workbooks with over 500 000 rows (Excel 2007/2010) and then needed to open the information in Excel 2003. In order to do that they had to split the information into pieces of a max of 65536 rows because that is the maximum amount of rows that a sheet in Excel 2003 can contain. Now, with this tool you can do that much faster.
  • Note:
  • Your original worksheet remains unaltered.
  • If you want to save the new created worksheets as separate files, then you can do this with the utility "Export » Export worksheets as separate files...
  • Split the selected range into multiple worksheets...
  • Example of the "For every new value/group in column" option. A new sheet is when the brand name in column A changes and that data is copied to the new worksheet:A new sheet is created for each car name in column A, with that data
  • NEW: Formulas » Replace the range names used in formulas with their cell reference (on selected sheets)
  • This utility replaces the range names used in the formulas on the selected sheets with their cell references.
  • For example if you have a value in cell C10 with the range name 'quantity' and you used a formula such as '=A1*quantity', then this utility will replace that formula with '=A1*C10'.
  • Select the sheets and start the utility:
  • Select the sheets and start the utility
  • The range names have been replaced with their cell references.
  • As you can see, if needed the utility adds the sheetname for the cell reference too if needed:
  • The range names have been replaced with their cell references
  • At the end a report with the changes that were made is presented:
  • A report with the changes that were made
  • NEW: Information » Copy the path and filename of current workbook to clipboard
  • This will put the path and filename of your current workbook to the clipboard.
  • You can then paste it into another application.
  • This can for example be useful if you're working on a file and want to inform a collegue and tell him/her in an email where he/she can find the file.
  • Web » Clean information that is copied from websites...
  • Now has buttons to quickly check, uncheck or inverse all options.
  • This utility is handy to quickly clean up data in general.
  • Clean up data
  • Subscript the numbers in chemical equations
  • via: ASAP Utilities Options » New tools in development (English only)
  • This utility will subscript the numbers in chemical notations such as Al(OH)3, AlF6Li3, AlO2, Al(NO3)3, Au2(SeO4)3, Ca(VO4)2, H6TeO6, KAlMg3Si3O12H2, Ca(NO3)2 · 4H2O, etc.
  • It automatically detects which numbers should be subscripted.
  • Start the new 'Chemical Equation' tool
  • Quickly turn your chemical equations into nicely formatted ones
  • NEW: Report the formulas used in the worksheets in your workbook
  • via: ASAP Utilities Options » New tools in development (English only)
  • This utility creates a report that lists all the formulas that are used in the worksheets in your workbook.
  • Report formulas
  • 464-report-formulas-confirmation.png
  • You can click on the cell in the report to jump to the cell in the reported workbook:
  • Example report of reported formulas
  • General, Startup-questions
  • We removed the startup-questions (such as "Do you want to convert all text in the selected cells to UPPERCASE?") from several tools.
  • These tools either don't change your data or settings, or can be easily undone or canceled nowadays.

New in ASAP Utilities Home & Student 4.6.3 (Oct 9, 2012)

  • Improvements
  • Improved startup error message
  • ASAP Utilities does not (yet) support the 64-bit edition of Excel 2010.
  • Besides a warning about this during the installation, the program will now also tell you this when you start ASAP Utilities in Excel 2010 64-bit (instead of giving an error message).
  • Just to be clear, ASAP Utilities does work with both 32-bit and 64-bit Windows.

New in ASAP Utilities Home & Student 4.6.2 (Oct 9, 2012)

  • Improvements
  • Export » Export worksheets as separate files...
  • Fixed the bug that caused export files, that were in text-format, to be empty.
  • This bug was unfortunately introduced with version 4.6.1, our apologies for this.