Refer: https://www.asap-utilities.com/faq-questions-answers-detail.php?m=380

Changes in version 8.7.3 - June 11; 2025$$$Published: March 17; 2025 (latest revision June 11; 2025)$$$reference id: QA0377$$$New/improved$$$Fixed a bug where some internal functions of ASAP Utilities were not properly hidden; causing them to appear in Excels formula dropdown; where they looked particularly odd$$$Improved compatibility with non-persistent VDI environments.$$$A few other small improvements.

Changes in version 8.7.3 - June 11; 2025$$$Published: March 17; 2025 (latest revision June 11; 2025)$$$reference id: QA0377$$$New/improved$$$Fixed a bug where some internal functions of ASAP Utilities were not properly hidden; causing them to appear in Excels formula dropdown; where they looked particularly odd$$$Improved compatibility with non-persistent VDI environments.$$$A few other small improvements.

Changes in version 8.7.2 - November 29; 2024$$$Published: November 28; 2024 (latest revision November 29; 2024)$$$reference id: QA0372$$$Designed to simplify your work$$$We are working with great enthusiasm; for over 25 years already; to ensure that ASAP Utilities continues to evolve and stay one of the worlds most useful and popular add-ins for Excel users.$$$$$$Finished$$$On November 29; 2024 the new version 8.7.2 has been released.$$$$$$Download$$$New/improved$$$Export › 1. Export selection or active sheet as new file...$$$Updated the Open the export in Windows Notepad instead of saving it option to handle recent changes in Notepad in Windows 11.

Changes in version 8.7.1 - November 25; 2024$$$Published: November 25; 2024$$$reference id: QA0369$$$$$$New/improved$$$General$$$Made several text improvements for clarity and consistency.$$$$$$Bug fix$$$Resolved an issue where new users might encounter an error message only on their first launch of ASAP Utilities after installation. The error did not occur on subsequent launches.$$$The error message displayed was:$$$Sorry; an error occurred while trying to save your favorites menu:$$$\asap_custom_menu.ini$$$This bug was introduced in version 8.7 and has now been fixed.

Changes in version 8.7 - November 14; 2024$$$Published: July 18; 2024 (latest revision November 15; 2024)$$$reference id: QA0365$$$Designed to simplify your work$$$We are working with great enthusiasm; for over 25 years already; to ensure that ASAP Utilities continues to evolve and stay one of the worlds most useful and popular add-ins for Excel users.$$$$$$Finished$$$On November 14; 2024 the new version 8.7 has been released.$$$$$$Download$$$New/improved$$$General$$$We made various small improvements and resolved minor issues that were either discovered by our team or reported by clients.$$$$$$Date Picker shortcut: Control+Alt+T$$$The Date Picker calendar popup has been added to the Favorites & Shortcut Keys menu and can now be launched using the shortcut Ctrl+Alt+T.

Changes in version 8.6 - May 15; 2024$$$Published: March 28; 2024 (latest revision May 15; 2024)$$$reference id: QA0361$$$Designed to simplify your work$$$We are working with great enthusiasm; for over 25 years already; to ensure that ASAP Utilities continues to evolve and stay one of the worlds most useful and popular add-ins for Excel users.$$$$$$Finished$$$On May 15; 2024 the new version 8.6 has been released. Download$$$$$$Supported Excel versions$$$ASAP Utilities 8.6 works with:$$$$$$Excel 365 Desktop$$$Excel 2024 (preview)$$$Excel 2021$$$Excel 2019$$$Excel 2016$$$Excel 2013$$$Excel 2010$$$On any Windows system that meets the Excel system requirements.$$$$$$New/improved$$$NEW: Numbers & Dates › 17. Date Picker...$$$The date picker popup simplifies selecting and inserting dates into your worksheet.$$$$$$It displays a visual calendar; allowing you to quickly identify and select dates instead of having to type the date manually.$$$$$$It is handy for quickly finding and entering dates accurately; without errors in format or value.$$$$$$Browse by year and month to pick a date.$$$Select a date and it automatically inserts it into the active cell.$$$If a cell isnt formatted as a date; the Date Picker will insert the picked date and apply the short-date format according to your regional Windows setting.$$$The Date Picker popup floats; so you can easily keep it visible and select the cells to insert a date.$$$You can enable the Date Picker to show automatically when double-clicking a date cell. It then appears when you double-click a cell with a date or date format.$$$You can choose to have the calendar view start with today’s date (default); or the date of the selected cell.$$$You can choose the starting day of the week: Monday; Sunday; or Saturday.$$$The calendar shows (ISO) week numbers for easy identification.$$$Choose to close the form after date entry or move to the next cell.$$$Simply close the Date Picker by pressing the ESC-key or clicking the X in the title bar.$$$$$$Screenshot 1; week starts on Sunday:$$$Easily insert dates from a calendar pop-up$$$$$$Screenshot 2; week starts on Monday:$$$Easily insert dates from a calendar pop-up$$$$$$Screenshot 3; Settings:$$$Date Picker pop-up settings$$$$$$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.$$$$$$Free upgrade if you purchased your license in 2016 or later$$$If you purchased your license in 2016 or later (version 7.x) then you get version 8.6 free of charge. You can use the same license details.$$$If you purchased a license longer ago; then please contact us for a 50% discount to upgrade to versions 8.$$$$$$To upgrade to a newer version of ASAP Utilities that is covered by your license; just install the new version on top of the existing version on your computer.$$$ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.

Changes in version 8.5 - February 29; 2024$$$Published: Januari 15; 2024 (latest revision March 21; 2024)$$$reference id: QA0359$$$Finished$$$Were launching version 8.5 of ASAP Utilities on the most magical day of the year - February 29th!$$$Just like this leap day gives you an extra 24 hours; our Excel add-in gifts you extra time all year round.$$$$$$Download$$$Supported Excel versions$$$ASAP Utilities 8.5 works with:$$$$$$Excel 365 (both 32- and 64-bit version)$$$Excel 2021 (both 32- and 64-bit version)$$$Excel 2019 (both 32- and 64-bit version)$$$Excel 2016 (both 32- and 64-bit version)$$$Excel 2013 (both 32- and 64-bit version)$$$Excel 2010 (both 32- and 64-bit version)$$$On any Windows system that matches the Excel system requirements.$$$$$$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.$$$ASAP Utilities Options › 1. Settings; language and contact information...$$$Microsoft Offices Visual Basic for Applications (VBA) still does not natively support mouse wheel scrolling in UserForms/dialog boxes.$$$This has been a request to Microsoft for decades already. Users requested it to us too; and since Microsoft still hasnt implemented it; we investigated and implemented a workaround for this in ASAP Utilities.$$$You can now enable this via the option: Enable mouse wheel scrolling for dialog boxes$$$$$$Enable Mouse Wheel Scrolling$$$$$$There appears to be a bug in certain Excel 365 builds(source 1; source 2) which currently may cause this new functionality to crash those Excel builds/versions; so be careful when you try it the first time.$$$To try it; just enable the option; click OK; close the settings window; and then for example choose ASAP Utilities › Info...$$$If that crashes Excel (sometimes you see a cryptic Microsoft Visual Basic for Applications - Unexpected error (35010); go back to the options and turn off this setting until you have updated your Excel version/build.$$$$$$Free upgrade if you purchased your license in 2016 or later$$$If you purchased your license in 2016 or later (version 7.x) then you get version 8.5 free of charge. You can use the same license details.$$$If you purchased a license longer ago; then please contact us for a 50% discount to upgrade to versions 8.$$$$$$To upgrade to a newer version of ASAP Utilities that is covered by your license; just install the new version on top of the existing version on your computer.$$$ASAP Utilities will then automatically recognize your settings and license information if you have already entered that previously.

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...$$$Save your dataset in JSON format$$$Save Excel sheets in JSON format$$$$$$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 Excels last cell$$$Fixed a bug that was introduced in version 8.3 where; if your dataset didnt begin in row 1 or column A; it could give an error message and mistakenly delete one or more rows or columns of data at the end of your dataset.$$$$$$

New/improved$$$General$$$Some ribbon icons have been refined to look sharper on displays with a Windows Display Scale setting over 200%.$$$$$$All forms in our app now use a modern font; aligning with the one Excel uses.$$$This offers a subtle upgrade from the standard font found in xlam add-ins; aiming for a more harmonious user experience.$$$$$$Weve addressed some known issues and made a few small; yet significant; improvements to enhance your experience. $$$Columns & Rows › 10. View and manage hidden rows and columns...$$$The layout has been refined to reveal more information from hidden rows and columns all at once. Additionally; a horizontal scrollbar has been introduced for effortless navigation when row or column headers are too lengthy to display in full.$$$Easily see and unhide hidden rows or columns$$$$$$Range › 1. Find and/or replace in all sheets...$$$Corrected a bug originating from version 8.0.2 that caused the search and replace to fail in cells with over 8195 characters; resulting in no matches being found even when they existed.

New/improved$$$General$$$$$$Weve addressed some known issues and made many small; yet significant; improvements to enhance your experience. $$$The localized per language ribbon/menu xlam-files no longer use an API call.$$$This is related to the following if your company blocks Win32 API calls from Office macros:$$$https://www.asap-utilities.com/faq-questions-answers-detail.php?m=340$$$$$$

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.$$$$$$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.