[last updated: November 15, 2024] Introduction The past decades we often received support requests that we found out were related to/caused by (often already fixed) bugs in Excel. This article shows information on how to update your Excel installation and also contains links to the Microsoft articles with all the detailed information about what has been fixed and ...

Feedback appreciated This is our first video in a new series of tutorials. For accessibility and since many people view tutorials at work (with sound turned off), the video is with call-outs and subtitles. We are still experimenting with the right way to do this, so my apologies in advance in case the video tutorial looks a ...

The past week we have finally made a few important improvements to both our website and our blog. It is not finished yet, but already much improved. This blog has a new look and both our website and blog are now so called "responsive", which means that you can easier to view our site on devices ...

Save 5 minutes a day by using ASAP Utilities to quickly export your data in a specific file-format. "Easily export your selected cells in a proper file format" Have you ever wondered why Excel cannot just export just your selected cells to a new file? Or why European users cannot simply create proper CSV files from Excel? In ...

Save 5 minutes a day by using ASAP Utilities to quickly clean up your data in Excel. "Easily optimize and clean your dataset" One of the first things you often need to do, when you import a file or copy information, is clean it up before you can analyse the data. There are many things that can ...

Is Excel 2019 just Excel 2016 with a new name? Excel developers can use the command "Application.Version" to get the version of Excel. However, the new Excel 2019 returns the same version number as Excel 2016 (16.0). We expected Excel 2019 to return the number 17.0 (or 19.0) but certainly not 16.0. We recently purchased and installed the new ...

“Everyone can now install ASAP Utilities” One of the improvements in the new version 7.3 is that we have created a special version of the setup that can be installed by standard/limited users. We're currently still working on the new version but it's already available as a pre-release. By default only administrators and power users can install software ...

Save 5 minutes a day by using ASAP Utilities to quickly fix the numbers that Excel may not recognize. "Easily make Excel recognize the numbers in your selection" Sometimes Excel fails to recognize numbers properly, which causes unexpected results when you sort, filter, or use formulas. For example, when you import a file that was created in another ...

Save 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or trailing spaces can ...

Save 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. "Did you ever have to SUM by Color or Count by cell Color?" I have a column that needs summed, but only the cells that are green... Working with cell colors can help to make your Excel workbook ...