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 [...]
Posted on December 20th, 2007 by Bastien
Filed under: General | Comments Off
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 [...]
Posted on October 25th, 2007 by Bastien
Filed under: General, Excel 2007 info | 12 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, General, Excel 2007 info | No Comments »
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 [...]
Posted on October 9th, 2007 by Bastien
Filed under: ASAP Utilities, General | No Comments »
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 [...]
Posted on July 10th, 2007 by Bastien
Filed under: General | No Comments »
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 [...]
Posted on July 9th, 2007 by Bastien
Filed under: ASAP Utilities, General, Excel 2007 info | 15 Comments »
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 [...]
Posted on June 21st, 2007 by Bastien
Filed under: General | 2 Comments »
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 [...]
Posted on May 28th, 2007 by Bastien
Filed under: General | No Comments »
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").Value
The 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 [...]
Posted on April 24th, 2007 by Bastien
Filed under: General | 1 Comment »
I have been getting a lot of comment spam on this blog. I've just removed over 20.000 comments from the database. Apparently Wordpress still stores the comment if you mark it as spam. I haven't looked in the code if it uses this for some clever techniques to detect future spam. Right now I just [...]
Posted on April 19th, 2007 by Bastien
Filed under: General | 2 Comments »
