New version in progress – pre-release 4

menu_start_the_last_used_utility.png

I have been working on the new version of ASAP Utilities today and I've just released another preview version, ready for download and testing. New ASAP Utilities Options » Start the last used utility again... This will re-start the last run utility used in ASAP Utilities. For example if the last utility you used was 'Export selection as HTML ...

Excel file loads slowly the first time that it is opened in Excel

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

Fix the slow startup of Excel 2007

Excel 2007 Splash Screen

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

New version in progress – pre-release 3

new_convert_dates_change_case_cropped.png

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

PCtipp: Obercooles Programm – Excel-ABC: 29 Tipps

pctipp_june_2007_obercooles_programm.png

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

New version in progress – pre-release 2

New: User Guide in the ASAP Utilities menu

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

New version in progress – pre-release

Development in progress

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: http://www.asap-utilities.com/faq-questions-answers-detail.php?m=149 At this moment the ...

Microsoft: Description of the undiscovered tips about Excel

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

"I use this tool all the time, how can I access it faster?"

Organize your favorite tools

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

How to increase the number of undo levels in Excel

How to increase the number of undo levels in Excel by changing the registry

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