I’ve been thinking lately about Excel and Office related add-ins. I tend to shun add-ins for one reason: They won’t be available to me if I’m using another machine. If I get used to selecting a certain menu item to, for instance, select cells by format and that menu item isn’t available because I’m using my wife’s machine, I will be frustrated. I don’t like being frustrated. A normal person would be happy that the convenience was available to him 99% of the time, but normality was never one of my vices.
I’m a bit of hypocrite, though, because I do use some add-ins. Right now I have MZ-Tools and VBA Code Cleaner installed. I guess because those are development related add-ins and I only develop on two machines, I can justify it. That is, I’m not likely to be creating any substantial code on any computers except my own. In reality I don’t use Excel, development or not, on any machines except my own. Which means that my logic is flawed and I really have no justification.
For that reason, I’m going to install some add-ins and see if I like them. I’m going to start with Power Utility Pak. I’m already beta testing the Excel 2007 version, so I might as well check out the Excel 2003 version too. What else should I try? Which add-ins are indispensable to you? Which are just nice? Which do you avoid?
Oh, and one more question. I’ve bought enough Walkenbach books that I’m sure I have a coupon for a free PUP, but what if I didn’t? How much are willing to pay for an add-in? That’s a pretty broad question, I know, so here’s something more specific. How much would you pay for the add-ins you have installed now?