Google Desktop Search slows down Excel

Google Desktop Search

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

Check for Microsoft Updates

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

Pre-release ASAP Utilities version 4.2.2 RC1

I have just released a pre-release of the new version of ASAP Utilities which contains several extended utilities (mainly import/export) and a few bug fixes. I would like to thank everybody for their feedback! New/improved Export » Export worksheets as separate files...Improved, you can now specify in which file-format you want to save the sheets.If you have Excel ...

Review: ASAP Utilities – You Sexy Thing

ASAP Utilities Review

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 tempers Disadvantages: ...

Video: How to fix trailing minus signs in Excel with ASAP Utilities

Numbers with a trailing minus sign

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

Video: How to delete all empty rows in Excel with ASAP Utilities

Example file with empty rows that need to be removed

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

Problem with copying filtered data in Excel 2007 + workaround

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

Protect sheets: The EnableSelection property is not saved + Excel update fix

Protect sheets: The EnableSelection property is not saved + Excel update fix

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

How to delete the first 3 characters in a column - before

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

Copy values to empty cells below filled cells in selection - before

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