Daily Dose of Excel

Workbook Window States: Maximized, Restored, Minimized, Limbo

Daily Dose of Excel — Tue, 18 Jun 2013 12:30:30 GMT

I have been seeing some strange behavior in Excel 2010. I run 2010 on at least three machines and this only happens on one. It just so happens that the one machine is the one I have the least control over. To my knowledge, windows inside of Excel have three states: Minimized: The windows is [...] Read More......(read more)

Going Home with Frozen Panes

Daily Dose of Excel — Tue, 11 Jun 2013 12:30:54 GMT

I like to split a worksheet and freeze the panes so I can see the row and column headings when I scroll. Like me, I’m sure you’ve done it a million times. In that state, the Ctrl+Home shortcut will take you to the intersection of the split panes rather than A1 (where it takes you [...] Read More......(read more)

Importing Fixed Width Text Files with ActiveX Data Objects

Daily Dose of Excel — Fri, 10 May 2013 15:13:20 GMT

A few weeks ago I was struggling with fixed width text files. Remember 1995? Me neither, but I’m living it every day. I happened upon a stackoverflow.com post that dealt with using ADO for this purpose. I don’t remember the post, so no link. It did, however, lead me to this MSDN article, which was [...] Read More......(read more)

Importing Fixed Width Text Files

Daily Dose of Excel — Thu, 09 May 2013 01:34:12 GMT

I’ve been working with fixed width text files quite a bit lately. The built-in method for importing these files is terrible. First, it’s yet another wizard and I think it would be better as a single form (but then I think everything is better as a single form). The worst part, by far, is the [...] Read More......(read more)

Queen’s day sale

Daily Dose of Excel — Mon, 29 Apr 2013 18:58:16 GMT

As some of you may know, I’m Dutch and live in “The Kingdom Of The Netherlands”. Well, tomorrow is an important day for the Dutch people: Queen’s Day. More so, tomorrow is an extra special day. Not because our Queen abdicates to make room for King Willem-Alexander, but because my 24 hour “Queen’s Day sale” [...] Read More......(read more)

Draw a circle in an Excel chart

Daily Dose of Excel — Sun, 28 Apr 2013 06:24:23 GMT

By default, Excel has a limited number of charts. That does not mean that those are the only charts one can create. It turns out that with a little imagination and creativity, we can format and configure the default charts so that the effect is like many other kinds of charts. One of the more [...] Read More......(read more)

Analyze ‘free’ money

Daily Dose of Excel — Thu, 25 Apr 2013 06:40:17 GMT

Recently, I received yet another promotion from yet another company offering me money at zero percent interest with the predictable asterisk next to the zero percent. Instead of just shredding the offer I decided to create a downloadable Excel template to analyze the offer, which was an interest-free 18 month loan for a 4% transaction [...] Read More......(read more)

Date Picker Add-in for Excel 2011 for the Mac

Daily Dose of Excel — Sun, 21 Apr 2013 22:19:47 GMT

Hi all I upload a Date Picker add-in based on John Walkenbach’s Date Picker on my site for the Mac, this Date Picker will also be a part of to the PUP add-in for the Mac soon. This Date Picker for Mac Excel have local Day letters in the header and also local Date formats in the format [...] Read More......(read more)

Stop Replying to Yourself

Daily Dose of Excel — Wed, 17 Apr 2013 13:01:28 GMT

In this edition of How to Make Outlook More Like GMail, I address the problem of replying to a message that you have sent. Inexplicably, Outlook creates a message addressed to you. That make sense from the standpoint that a reply to should be addressed to the sender. But then there’s the whole common sense [...] Read More......(read more)

Excel corrupts certain workbooks in migrating from 2003 to 2007

Daily Dose of Excel — Sun, 14 Apr 2013 07:04:06 GMT

I got a email from a client asking for help because Excel was “destroying,” to use his terminology, his 2003 workbook after conversion to the 2007 format. And, after analyzing the kind of change Excel made, I had to agree. The following in 2003 Figure 1 becomes, in 2013 (and in 2010), Figure 2 The [...] Read More......(read more)

Almost There

Daily Dose of Excel — Fri, 12 Apr 2013 21:22:39 GMT

Look how close I am. It’s like the odometer rolling over on my car. Read More......(read more)

Sample Fixed Width Text File

Daily Dose of Excel — Fri, 12 Apr 2013 11:49:27 GMT

I have a post or two in my head that deals with fixed width text files, something I’ve been dealing with quite a bit. Like me, you probably don’t run into fixed width text files in your personal life. It’s usually some crappy computer program at your job that forces you to deal with them. [...] Read More......(read more)

Com Add-ins Install problem on a machine with Office 2013

Daily Dose of Excel — Wed, 10 Apr 2013 16:38:50 GMT

Hi all VBE Bookmarks/Copy buffer and Tools>References Enlarger Com Add-ins http://www.rondebruin.nl/win/addins/vbeaddins.htm When I create this new page on my site about two very nice com add-ins from Jim Rech I found out that if you want to install them on a machine with Office 2013 you are missing a dll file that you need if [...] Read More......(read more)

RIP Live Mesh, hello Cubby

Daily Dose of Excel — Tue, 09 Apr 2013 00:54:29 GMT

Recently, I have had to make changes to my “computing infrastructure.” This is one of them. For the longest time I synchronized files between my laptop and desktop with the help of a flash drive. Then, I discovered Groove but it didn’t really fit the bill and I don’t remember why. It was on [...] Read More......(read more)

Worksheet as a chart – multiple conditional formats

Daily Dose of Excel — Sun, 07 Apr 2013 06:44:38 GMT

Several years back, I wrote an article on how to use multiple cells to simulate conditional formats that involved more than 3 conditions. Three versions of Excel later, I still receive requests related to this post. So, I updated it to include more screenshots and a downloadable file. In Excel 2003 and earlier, conditional formatting [...] Read More......(read more)