87 posts from: asap utilities / excel blog
ASAP Utilities 4.6.2 is has just been released
(Indexed 2010-09-03):
ASAP Utilities 4.6.2 is now available.The quick release after the previous version is due to an unfortunatea bug in version 4.6.1 in the "Export Export worksheets as separate files..." utility. It produced empty files if you choosed a text-format. Our apologies for that.If you already downloaded and installed 4.6.1, then please upgrade to 4.6.2.
Just released: ASAP Utilities 4.6.1
(Indexed 2010-09-01):
The new version of ASAP Utilities, 4.6.1 has just been released!A few nice additions have been added and a few bugs were fixed.We also fixed the startup error that sometimes occurred due to a bug in Excel 2010.Download ASAP Utilities 4.6.1View the changes.Manythanks to everyone who has contributed their feedback and tested the pre-release!PS.For the [...]
Almost ready: ASAP Utilities 4.5.9
(Indexed 2010-05-25):
I'm proud to mention that the new version of ASAP Utilities is almost ready!Based on the requests from many users, we have added several tools that will speed up your work in Excel.Furthermore we have improved many tools and fixed all known bugs.You can read what's new and download the pre-release from:http://www.asap-utilities.com/faq-questions-answers-det...(truncated)... of the many [...]
How to: Set column width and row height in centimeters or inches?
(Indexed 2010-02-23):
In standard Excel you can't set the height or with of cells in centimeters or inches. Creating square cells is also difficult because Excel uses different units for the width and height of cells.Setting the width and height in centimeters or inches can be helpful if you use the Excel for drawing purposes, such as [...]
How to: Split data table into multiple worksheets (and save time)
(Indexed 2010-02-11):
Many people have asked me the past years if ASAP Utilities has an option to split a table into several sheets. Either per so many rows, or by value. Until recently that wasn't possible, but now it is!. In cooperation with several users we have created a new utility.In the new version of ASAP Utilities [...]
How to: Remove or replace line breaks and carrage returns in cells
(Indexed 2010-01-18):
There are few quick methods to remove the line breaks and carriage returns in cells.By default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities.Let's say we have the following example.In this case the author has [...]
How to: Create a pipe delimited file
(Indexed 2010-01-15):
Last month I received the following question:I need to know how to convert an excel file into a pipe delimited file using the ASAP software.You can use the following tool to do this:ASAP Utilities Export Export selection or active sheet as new file...Then choose "CSV (comma separated value) or customer separated" and specify [...]
How to: Check the spelling on multiple or all sheets
(Indexed 2010-01-13):
Last week I received the following question:How we can spell check on all sheets. Can you add this in next version/update?Well, you can already do this in Excel.Just select all or multiple sheets and then when you start the Spelling (F7) the spelling check will take place on the selected sheets.
Excel 2010: Use the 32 or 64 bit edition? 32 Bit might be wiser…
(Indexed 2009-12-07):
The new version of Office, Office 2010 (Office twenty-ten) will be available in both a 32 bit and a 64 bit version. All previous version of Office were 32 bit. Office 2010 will be released in the first half of 2010.At this moment our advise is to install the 32 bit version of Office, even [...]
Parlez-vous franais? – Pre-release version 4.5.6
(Indexed 2009-11-30):
Parlez-vous franais? / Do you speak French?...then I have good news for you!ASAP Utilities is now also available in the French language.If you have the French language version of Excel then ASAP Utilities will start the first time automatically in French (Franais).You can change the language in the options dialogue: ASAP Utilities ASAP Utilities [...]
Remove all empty rows – within your selection
(Indexed 2009-11-09):
Last week I received the following question:Bastien,First, thank you so much for the best Excel add-on ever!Is there a way to remove empty rows in a only a selected section of the worksheet, not the whole worksheet?Or have I missed this option that is already included?Surely you can do this!The utility "Columns & Rows [...]
Russian review of ASAP Utilities and other Excel add-ins
(Indexed 2009-11-06):
Today the Russion website, 3D News, has written an article about Excel plugins (add-ins) and how these can speed up your work.We're proud to see that ASAP Utilities is also mentioned in the article. We are working for many years (over 10 years now) on ASAPUtilities to help you to speed up your work and [...]
Habla usted espaol? – Pre-release version 4.5.5
(Indexed 2009-11-03):
Habla usted espaol? (Do you speak Spanish?)Then I have good news for you: ASAP Utilities is now also available in the Spanish language.If you have the Spanish language version of Excel thenASAPUtilities will start the first time automatically in Spanish (Espaol).You can change the language in the options dialogue: ASAP Utilities ASAP Utilities Options [...]
New tool: How much time (and money) does ASAP Utilities save you?
(Indexed 2009-08-19):
These days, with all the economical issues, it is more then ever important to see where you can save money.You have probably already heard from others or experienced yourself that ASAPUtilities can save you a lot of time with your work in Excel. But how much time (and money) does it actually save you in [...]
Macro: Keep only ASCII characters 32-127
(Indexed 2009-08-13):
Last week I received the following question:I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file.You can use the "Text Advanced character remove [...]
How to: Remove all negative numbers
(Indexed 2009-08-03):
Last week I received the following question:Is there an ASAP Utilities function that can remove all negative numbers from a spreadsheet? I haven't found it yet. Yes there is. You can use ASAP Utilities to help you to quickly delete negative numbers.You can use the following tool to select all cells with negative numbers (values [...]
How to combine numerous sheets into a single sheet
(Indexed 2009-07-30):
I recently receive the following question:Is there a way to combine numerous Sheets into a single Sheet? I have an Excel document with 72 sheets, that I would like to be 1 continuous sheet. Thanks again for your help.You can use the following tool to put together the rows or columns from multiple [...]
Download pre-release version 4.5.4: German edition
(Indexed 2009-07-22):
ASAP Utilities is now also available in the German language.If you have the German language version of Excel, ASAP Utilities will now start in German (Deutsch). You can change the language in the options dialogue: ASAP Utilities ASAP Utilities Options ASAP Utilities options and settings...In ASAP Utilities you can now choose between the [...]
Video: How to move or resize the selected range in Excel with ASAP Utilities
(Indexed 2009-05-05):
The following video will show you how to how to move or resize the selected range in Excel by using ASAP Utilities.With this utility you can easily move or resize your selected range of cells.This utility will only change you selected range of cells only, not the data underneath it.By default you can start this [...]
Review in PC-WELT: The smartest Office-Addons
(Indexed 2009-03-06):
This March the German computer magazine PCWELT has an item on add-ins for Word and Excel. They call it the Microsoft Office Service Pack 2009 ;-)We're proud to mention that ASAPUtilities was listed as one of the addons; on page 49 and 50.The article translated into English:The smartest Office Addons"You work daily with Word, Excel [...]
How to: Remove all spaces, dashes and other garbage from numbers
(Indexed 2009-02-10):
I got a question from Ryan:I have a bunch of excel cells and I need them all to have no spaces and no dashes so the first one would be: 185444001 and so on. How can I use ASAP Utilities to remove all spaces and dashes?You can do this very quick with the following utility:ASAP [...]
How to: Remove all blank rows at once
(Indexed 2009-02-04):
If you have a lot of data it can be difficult to identify and remove the empty rows. There is no way in standard Excel to quickly remove all empty rows* so it can be a time-consuming job. You need to use a macro for that.Empty rows in your table can cause problems with sorting [...]
List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007
(Indexed 2008-11-19):
A bit off-topic but because working with shortcuts is often so much faster.I believe that shortcuts are are preferred when it comes to speed/productivity and reducing the chances on RSI.Microsoft: List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007http://support.microsoft.com/kb/290938Just in case you weren't aware, we have a list of the shortcuts in [...]
When Excel doesn’t recognize empty cells correctly
(Indexed 2008-11-13):
Enno asked me the following:"...When I value-copy ranges where the If-function was used with a return value of "" (empty string), the cells are not blank, hence ISBLANK() = FALSE.Could you add a feature to remove empty strings?..."Well, you can do this already with ASAP Utilities, although you cannot find it in the description of [...]
Prepare a document before sending it to others
(Indexed 2008-10-27):
When you send your Excel workbook to other people, sometimes you want to protect or hide certain parts.For example the formulas you used or temporary data in hidden columns.You can do this by using Excel's worksheet protection, however you should know that this protection is easily broken and not very secure.A better method to use [...]
Unhide all columns and rows
(Indexed 2008-10-21):
A short macro that will unhide all columns and rows in order to make all data visible again.Might be useful in some cases.Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = FalseEnd SubIf you want more control on which rows and/or columns to unhide, you can also use this tool [...]
Now available: ASAP Utilities 4.2.8
(Indexed 2008-09-24):
Yesterday the new version of ASAP Utilities was officially released.You can read the details in the newsletter or you can immediately proceed to the download page.Besides several bugfixes, these are two new things:Objects & Comments Delete all objects on current worksheetThis utility can now be used on multiple worksheets and has been renamed [...]
Replace formulas with their calculated results in multiple sheets
(Indexed 2008-09-16):
It's time to update this blog more often. I will do this by writing about questions I answered by email and that might be interesting for others too.Tom asked: Formula Convert formulas to their values: I was hoping you could tell me if there is there a way to do this for all the [...]
Excel 2007 sheet copy: Application-defined or object-defined error
(Indexed 2008-06-03):
When you use the code sheet.copy normally a new workbook is created with a copy of that particular sheet.However in Excel 2007 (SP1) if the original workbook contains a macro when you run the code the first time you (might) get the following error:I could only reproduce this error when the original workbook where [...]
New ASAP Utilities version 4.2.5 released!
(Indexed 2008-05-30):
The new version of ASAP Utilities for Excel has just been released!This new version 4.2.5, May 29, 2008 is improved in a several ways.Read the full newsletter:http://www.asap-utilities.com/asap-utilities-news...(truncated)...
New ASAP Utilities version 4.2.2 released!
(Indexed 2008-01-22):
ASAP Utilities version 4.2.2 (January 22, 2008) has just been released!I would like to thank everybody for their feedback!Among other minor updates, these utilities have been improved:- Export Export selected chart or range as image (file)...- Export Export worksheets as separate files...- Import Insert (delimited) text file...- Fill List filenames in [...]
Google Desktop Search slows down Excel
(Indexed 2007-12-20):
Do you read the website "Daily Dose of Excel"? If not, it is a very interesting website about Excel. Frequently updated and many interesting discussions.Today I want to share an article with you:This week Dick Kusleika posted a very interesting article where he quoted Charles Williams from DecisionModels.com. Charles Williams is an absolute expert in [...]
Office 2007 Service Pack 1 coming on December 11th
(Indexed 2007-12-06):
For your information, next Tuesday the first Service Pack for Office 2007 will be released.Service Pack 1 for the 2007 Microsoft Office system will be available for download on December 11th. We will be sharing more details at that time, but the improvements are focused on stability, performance and security.I'm very curious if the [...]
Review: ASAP Utilities - You Sexy Thing
(Indexed 2007-11-20):
Did you know that ASAP Utilities is sexy? I didn't too but I found out it is yesterday when I read the following review on the UK website Dooyoo! by raehippychick.I would like to share her enthusiasm with you.Review by 'raehippychick'Advantages: Brilliant for any Excel user - simple, easy to use, saves time and tempersDisadvantages: [...]
Video: How to fix trailing minus signs in Excel with ASAP Utilities
(Indexed 2007-11-09):
The following video will show you how to how to fix trailing minus signs in Excel by using ASAP Utilities. This can be useful if you have imported data from a system that reports negative numbers with a trailing minus.If you've ever worked with imported numbers you might have faced the problem that negative numbers [...]
Video: How to delete all empty rows in Excel with ASAP Utilities
(Indexed 2007-11-05):
The following video will show you how to remove all empty rows in Excel by using ASAP Utilities. This can be useful if you have a large amount of data imported or copied together that you now want to clean up.An approach to remove all empty rows can be to sort the worksheet. However if [...]
Problem with copying filtered data in Excel 2007 + workaround
(Indexed 2007-10-25):
Filter' align='right' style='margin-left:10px;'/>I just got an email that says you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 [...]
Protect sheets: The EnableSelection property is not saved + Excel update fix
(Indexed 2007-10-23):
Yesterday I got the following question: "When using the protect multiple sheets at once and checking only the select unlocked cells checkbox I find that once I save and reopen the sheets now behave as if both the select unlocked cells as well as the select locked cells seems to be in effect as I [...]
Video: How to delete the first 3 characters in a column in Excel with ASAP Utilities
(Indexed 2007-10-22):
The following video will show you how to strip the first 3 characters from a column in Excel by using ASAP Utilities.The example in the video shows a list of article numbers. Now in this case we want to remove the first 3 characters.This can be done with an Excel formula such as =RIGHT(A2,LEN(A2)-3) in a [...]
Video: How to fill empty cells with the value above in Excel with ASAP Utilities
(Indexed 2007-10-22):
The following video will show you how to fill empty cells with the value above in Excel by using ASAP Utilities.The example in the video shows a table with several car-brands. Now in this case we want the brand-names copied down so that the empty cells are filled with the brand names. After this we can [...]
Video: How to sort the sheet-tabs in Excel with ASAP Utilities
(Indexed 2007-10-18):
The following video will show you how to sort the sheet-tabs in alphabetical order in Excel by using ASAP Utilities.The example in the video show a workbook with several sheets with city-names:In the Excel menu choose ASAP Utilities » Sheets » Sort all sheets in alphabetical orderThen result will then look like:
Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer
(Indexed 2007-10-12):
The latest version of ASAP Utilities (pre-released today) will solve an issue that can appear when you have both Windows XP and Excel 2007 installed."After installing the latest version of ASAP-Utilities after upgrading to Office 2007, I began to encounter a problem with Excel 2007 where, upon clicking on an Excel file to open, the [...]
Pre-release ASAP Utilities version 4.2.1 RC3
(Indexed 2007-10-12):
I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.In this update have made a few small improvements and added a new worksheet function that make creating strong passwords easy:=ASAPRandomPassword(length, use_symbols)This new function will return a strong password which contains of - both uppercase [...]
Video: How delete leading, trailing and excessive spaces in Excel with ASAP Utilities
(Indexed 2007-10-11):
The following video will demonstrate you delete leading, trailing and excessive spaces from cells (trim) in Excel by using ASAP Utilities.The example in the video shows an address list with too many spaces:Several street- and city names contain a space at the beginning and/or at the end. Furthermore in a few names there are multiple spaces [...]
Video: How to extract hyperlinks in Excel with ASAP Utilities
(Indexed 2007-10-10):
The following video will demonstrate you extract hyperlinks from cells in Excel by using ASAP Utilities.The example in the video show a list of websites that I copied from my links-page. There is no easy way in Excel itself to get the hyperlinks from the cells. That's why I built such a functionality into ASAP Utilities.First [...]
Video: How to sort by color in Excel with ASAP Utilities
(Indexed 2007-10-09):
The following video will demonstrate you how to sort by color in Excel by using ASAP Utilities.It is not possible to sort by color in Excel. However we find that many people use colors to "tag" certain cells that need to be processed later.The example in the video show a list of keywords such as my [...]
Macro: Export each column to a separate sheet
(Indexed 2007-10-09):
Last week I got a question from Danielle: "I have a spreadsheet with 75 columns each containing between 48 to 50 rows. I would like to be able to export each column to either a separate sheet or a separate file. Sort of like the export worksheets as separate files function. Does this [...]
Video: How to remove leading zeros in Excel with ASAP Utilities
(Indexed 2007-10-08):
The following video will demonstrate you how to remove leading zeros from numbers within a range in Excel by using ASAP Utilities.This utility also works for numbers that are not recognized by Excel or are proceeded with an apostrophe (such as '2). You can usually recognize these numbers because they are left-aligned:The following video demonstrates how [...]
Pre-release ASAP Utilities version 4.2.1 RC2
(Indexed 2007-10-05):
I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.I have also experienced some crazy things with customizing the ribbon (qat) and empty Excel dialogboxes due to dynamic labels (getLabel). I will write more about that in a separate post.New/improvedFill Random numbering of [...]
Video: How to select/find unique values in a selection in Excel with ASAP Utilities
(Indexed 2007-10-03):
The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities.The video demonstrates how to select the color names that appear only once in the list:
Video: How to to list filenames in a folder in Excel with ASAP Utilities
(Indexed 2007-10-02):
The following video will demonstrate you how to list filenames in a folder in Excel by using ASAP Utilities.It is a perfect tool for creating catalogs of the files of your CD's and DVD's.The video will demonstrate how to import the contents of a folder and shows you how you can easily select a certain folder [...]
New version released: ASAP Utilities 4.2
(Indexed 2007-09-25):
Today I have released the new version of ASAP Utilities. This new version is improved in severals ways.I would like to thank everybody for their feedback the past months!» What's new» Versions History» DownloadI have changed the version number from 4.1 to 4.2 because the ASAP Utilities menu is now nicely integrated into the Excel [...]
Pre-release ASAP Utilities version 4.1.3 RC4
(Indexed 2007-09-13):
Yesterday I have published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.Two new utilitiesSheets Freeze panes on multiple sheets at onceFreeze panes on all or all selected sheets at once bases on your current selection.Normally in Excel you can only do this one one sheet [...]
Pre-release ASAP Utilities version 4.1.3 RC3 (Excel 2007 ribbon)
(Indexed 2007-08-30):
I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing.The major change in this version is in combination with Excel 2007 where ASAP Utilities now has its own tab in the ribbon.Preview with the blue (Excel default) theme:Preview with the black theme: Round numbers [...]
Preview ASAP Utilities ribbon for Excel 2007
(Indexed 2007-08-28):
I am currently working on an Excel 2007 ribbon-menu for the new ASAP Utilities.Right now the ASAP Utilities menu is visible in the Add-ins tab but the new version will have its menu integrated in the ribbon.Preview of the new ASAP Utilities menuA preview of the new ASAP Utilities ribbon in Excel 2007:More information and [...]
Pre-release ASAP Utilities version 4.1.3 RC2
(Indexed 2007-08-10):
I have made a few improvements to ASAP Utilities based on the advice of several people.Added:Fill Insert current date and time with secondsInsert the current date and time into the active cell. Unlike Excel's built in shortcut "Control+:" this utility also inserts the seconds. (timestamp)By default this utility can be started with the shortcut [...]
New version released: ASAP Utilities 4.1.2
(Indexed 2007-07-16):
Today I have released the new version of ASAP Utilities. This new version is improved in severals ways.I would like to thank everybody for their feedback the past months!» What's new» Versions History» DownloadUp next: A special ASAP Utilities menu in the Excel 2007 ribbon. (However, only a very small percentage of the Excel people [...]
Excel file loads slowly the first time that it is opened in Excel
(Indexed 2007-07-10):
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
(Indexed 2007-07-09):
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 files from within the Explorer:If I click on an xls file Excel opens with a blank window which delaysIf [...]
PCtipp: Obercooles Programm - Excel-ABC: 29 Tipps
(Indexed 2007-07-04):
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.chwww.pctipp.ch/archiv/archivj.asp?yy=200...(truncated)...
New version in progress - pre-release 2
(Indexed 2007-07-04):
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 [...]
Microsoft: Description of the undiscovered tips about Excel
(Indexed 2007-06-21):
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?”
(Indexed 2007-05-28):
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
(Indexed 2007-05-28):
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 [...]
Video: Apply a formula to selected cells (*10) with ASAP Utilities
(Indexed 2007-05-16):
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.
Video: How to make text UPPERcase in Excel with ASAP Utilities
(Indexed 2007-05-15):
The following video will demonstrate you how to make text UPPERcase in Excel with ASAP Utilities (all capitals). A quick alternative of Excel's =UPPER() function.
Range.Value = Range.Value, isn’t it?
(Indexed 2007-04-24):
There are several ways to copy information from one sheet to another. Today I discovered an inconsistancy while using something similar like the following code:Sheet1.Range("A1:A100").Value = Sheet2.Range("A1:A100").ValueThe above code does not work correctly if the cells in sheet 2 are formatted in currency- or accounting format. In that case Excel does not copy the original [...]
Help, my columns are displayed backwards
(Indexed 2007-01-03):
Just got a question that migh be interesting to show here about columns that are displayed backwards. The columns are in reversealphabetical order and start at the upper right hand corner. The row numbers are on the right side of excel instead of theleft.The Problem: Recently, when I opened Excel, the columns were BACKWARDS. [...]
Tip: Insert multiple rows at once
(Indexed 2006-11-13):
Inserting multiple rows "the Excel way"If you want to insert multiple rows at once the standard procedure is to first select multiple rows and then use the "Insert" command.For example if you want to insert 10 rows between A1 and A2, you first have to select rows 2:11 and then insert the rows.Inserting multiple rows [...]
New version in progress: October 17, 2006
(Indexed 2006-10-17):
The new version of ASAP Utilities is still in progress. A few things took more time than I expected and I took the opportunity to add a few worksheet functions and a new utility.You can download 4.0.5 RC3, October 17, 2006:ASAPUtilities_setup_4-0-5-RC3.exe (1.1 MB)Major reason for this release are a few bugfixes.Depending on the feedback [...]
New version in progress: October 6, 2006
(Indexed 2006-10-06):
A new version of ASAP Utilities is in progress.You can download 4.0.5 RC2, October 6, 2006:ASAPUtilities_setup_4-0-5-RC2.exe (1.1 MB)Major reason for this release are a few bugfixes.Depending on the feedback I will release this version officially within a couple of days.I have also code-signed this version of ASAP Utilities and it's setup.ImprovedGeneralExcel XP/2002/2003: Improved information [...]
New version in progress: October 4, 2006
(Indexed 2006-10-04):
A new version of ASAP Utilities is in progress.You can download 4.0.5 RC1, October 4, 2006:ASAPUtilities_setup_4-0-5-RC1.exe (1.1 MB)Major reason for this release are a few bugfixes.Depending on the feedback I will release this version officially within a couple of days.ImprovedGeneralExcel XP/2002/2003: Improved information on how to solve the problems during the startup when no [...]
Screenshots of the different Excel versions
(Indexed 2006-09-27):
I have always wondered how Excel looks in other countries. In my office we use both the international and the Dutch version(s) of Excel.Today I have created a new page on the main website displaying screenshots of the various Excel versions in different countries. At this moment only international and Dutch ranging from Excel 97 [...]
New version: September 20, 2006
(Indexed 2006-09-20):
A new version of ASAP Utilities is just released. You can download 4.0.4, September 20, 2006 from the main website:www.asap-utilities.com/download-asap-utilities.phpMajor reason for this release are a few bugfixes. Thank you all for the feedback on the preview version.Improved utilitiesDelete leading and trailing spacesCells with (array)formulas and errors will be skipped.Delete leading, trailing and excessive spacesCells [...]
New version in progress: September 19, 2006
(Indexed 2006-09-19):
A new version of ASAP Utilities is in progress. You can download 4.0.4 preview, September 19, 2006:ASAPUtilities_setup_4-0-4-preview.exe (1.1 MB)Depending on the feedback I will release this version officially withing a couple of days.Major reason for this release are a few bugfixes. ImprovedDelete leading and trailing spacesCells with (array)formulas and errors will be skipped.Delete leading, [...]
Excel startup errors and speed problems
(Indexed 2006-09-05):
There are several things that can affect the speed of Excel or cause startup problems.I've found five good sites that discuss these problems and offer solutions:Chip Pearson: Startup Errors In ExcelMicrosoft: How to troubleshoot startup problems in ExcelDavid McRitchie: Slow Response, Memory Problems, and Speeding up ExcelJKP: Fixing Startup problemsContextures: Answers to Frequently Asked Questions [...]
New version: August 29, 2006
(Indexed 2006-08-30):
A new version of ASAP Utilities is available:4.0.3 (August 29, 2006).Major reason for this release are a few bugfixes, two new worksheet functions and an expanded description of the utilities. New worksheet function: =ASAPExtractNumbers(ref) This function extracts the numbers from a given range or value.New worksheet function: =ASAPStripNumbers(ref) This function strips the numbers [...]
Problems after a recent Microsoft upgrade?
(Indexed 2006-08-23):
After installing a recent Microsoft upgrade a few people have been unable to use the ASAP Utilities. This is because somehow Excel has put ASAP Utilities on the "disabled items" list.To solve this to: "Help" > "About" in the Excel menu.Then click on the disabled items button and when ASAP Utilities is listed there, enable [...]
New version: 31 july 2006
(Indexed 2006-07-31):
A new version of ASAP Utilities is available: 4.0.1 (31 july 2006).I have also updated the User Guide. Major reason for this release is a few bugfixes. New worksheet formula: =ASAPSheetName() Returns the name of the sheet the formula is placed on.System Rename current file If you specified a filename of a [...]
New version: 22 june 2006
(Indexed 2006-06-22):
A new beta version of ASAP Utilities is available:3.11.ab beta (22 may 2006).Major reason for this release were problems in combination with Excel 2000. The merge files or import Excel file made Excel 2000 produce errors or crash. I have created a workaround for this. (the command workbooks.open makes Excel 2000 crash if it is [...]
Comments are open again
(Indexed 2006-06-05):
I'm back from a few days of mountainbiking in the Dutch Mountains (hills...).Comments are no longer held for moderation, unless the spam filter holds them. The past days 184 spam-comments have been placed. If I have some spare hours I will update the comment-module with better spam-protection. WordPress already has some nice tools: codex.wordpress.org/Combating_Comment_Spam.Tommorrow I'm [...]
Favorite project
(Indexed 2006-05-19):
After spending many weeks programming in PHP/MySQL for two projects with a very tight deadline and some small Excel projects, I've found the time to work on my favorite project again.I'm working my way through all the comments and recommendations I received the past month. Some of them are bug reports, spelling corrections, tips [...]
New version: 4 april 2006
(Indexed 2006-04-04):
A new beta version of ASAP Utilties is available:3.11.w beta (4 april 2006).In this version a few bugs in the protect/unprotect all sheets have been fixed. Furthermore the protection in Excel XP/2002/2003 that enables you to select (un)locked cells (or not) has now been implemented too.
Toggle fullscreen with F11
(Indexed 2006-04-03):
This evening I needed to create a flowchart. Excel is my favorite application to do this. However the screenresolution on my notebook is a bit less then my computer at work, so I wondered how I could view my information better. Of course you can set the zoom to less then 100% but then I [...]
From beta to final version?
(Indexed 2006-03-30):
Today I have released a new beta version, 3.11.u (30 march 2006). The major change here is the new improved progress indicators. Furthermore I have fixed a bug in the "Unprotect sheets" functions. (popup for password if it didn't match).Please let me know if you think this version good enhough to become the official new [...]
ASAP Utilities 3.11 beta 28 march released
(Indexed 2006-03-28):
Today I have released version 3.11.t beta 28 march 2006.This new version contains some bugfixed (Export sheets as separate files in Excel 2000) and has an improved progress indicator. Furthermore the advanced sorting capabilities have been expanded. You can now sort dates directly by: . Year-Month-Day . Year-Day-Month . Month-Day-Year . [...]
ASAP Utilities 3.10b released today
(Indexed 2006-01-24):
Update: version 3.10c is released, I changed the download link in this post.ASAP Utilities released its new version (3.10b) today!We make you the company's excel guru!ASAP Utilities is a free and easy to use Add-In for MS Excel 97, 2000, 2002, XP and 2003. The utility contains over 300 functions to make your work easier [...]