General Excel question: Recently I have been getting this same question by several customers. If they open a file in Excel, the first time it takes a very long time. If they then save the file and open it again it loads much faster. This occurs when you open an Excel file that has been made in ...

Recently I have been receiving a few emails about people telling me that their Excel 2007 would startup very slowly with ASAP Utilities installed. The delay also occurred without ASAP Utilities if they click on an Excel file from within the Explorer: If I click on an xls file Excel opens with a blank window which delays... If ...

I have just released a third preview-version of the new version of ASAP Utilities. This version solves a few more bugs and expands the Text Convert dates... utility with the option to change the case of the new dates: This new version will probably officially be released as a new version at the beginning of July. More information ...… Read more... "New version in progress – pre-release 3"

Last month the Swiss computer magazine PCtipp wrote an article with 29 useful tips for Excel. ASAP Utilities was one of their tips. They gave it a great title (which made me dance around in the office for a while!). The full article is available on their website: www.pctipp.ch www.pctipp.ch/archiv/archivj.asp?yy=2007&ii=06

I have just released a second preview-version of the new version of ASAP Utilities. This version solves a few more bugs. Furthermore the User Guide is now included in the setup and accessible from within the ASAP Utilities menu. I hope this way more people will be aware of the User Guide and spend some time reading it to ...

I have just released a preview-version of the new version of ASAP Utilities. This version solves nearly all the bugs that have been reported so far. Furthermore some utilities we added or improved. This new version will probably officially be released as a new version at the beginning of July. More information and download: //www.asap-utilities.com/faq-questions-answers-detail.php?m=149 At this moment the ...

Microsoft has written an article on how some things in Excel can be done without the use of macro's. An interesting list. However I remember that back in 1999 when I use their approach to "Exclude duplicate items in a list" I found out that this was limited to approximately 1000 unique items. This article describes some ...

Last week I received the following question: "Is it possible to display a tool icon amongst the normal excel icons. I use the "Find and remove external links" all the time and would like to have it closer to hand and not first open ASAP Utilities/System/........... Thank you for this great Software" In stead of adding it to the ...

By default, Excel keeps track (allocates RAM) of 16 "undo" levels. Undo levels provide an undo history for most actions that you perform in Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. If the undo history is set to zero, no memory is allocated for undoing ...

The following video will demonstrate you how to apply a formula to your selected cells in Excel with ASAP Utilities. A quick alternative for creating extra columns or use the copy-pastespecial methods. In the example I show you how to quickly multiply all cells in your selection with 10. Note: This old video is no longer available and ...