Jeff recently asked: I really like your product but just came upon a capability it is missing: Delete trailing spaces (but keep all other spaces). I expect it would be simple enough to add; would you? I never expected anyone to need a tool to only remove the trailing spaces but he needs it on [...]

Posted on September 18th, 2008 by Bastien
Filed under: ASAP Utilities, General | Comments Off

Max asked the following: Can the "Fill > fill up with leading zero's" option under be made to work on leading or trailing zeros? For instance, if I have three numbers: 1 12 123 I would run the option to fill them with trailing zeros so they would look like: 1000 1200 1230 We want [...]

Posted on September 17th, 2008 by Bastien
Filed under: ASAP Utilities, General | 1 Comment »

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

Posted on September 16th, 2008 by Bastien
Filed under: ASAP Utilities, General | 2 Comments »

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

Posted on June 3rd, 2008 by Bastien
Filed under: Excel 2007 info, General | Comments Off

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

Posted on December 20th, 2007 by Bastien
Filed under: General | Comments Off

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 works. You can [...]

Posted on October 25th, 2007 by Bastien
Filed under: Excel 2007 info, General | 49 Comments »

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

Posted on October 23rd, 2007 by Bastien
Filed under: ASAP Utilities, Excel 2007 info, General | Comments Off

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 function already [...]

Posted on October 9th, 2007 by Bastien
Filed under: ASAP Utilities, General | Comments Off

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

Posted on July 10th, 2007 by Bastien
Filed under: General | Comments Off

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

Posted on July 9th, 2007 by Bastien
Filed under: ASAP Utilities, Excel 2007 info, General | 61 Comments »