Author: Ken Puls

In Seattle

Dee and I are currently in Seattle, as I'm attending the MVP summit for the 3rd year in a row. We're now happily checked in to the Westin, and waiting for registration to start tomorrow. We came down on the

Read More »

This is a post about speech recognition

I tried to set up my laptop today to use the speech recognition native in Microsoft Windows.  I found it pretty hard to actually get it to recognize my voice the first time around.  It doesn’t actually feel quite as

Read More »

Why doesn’t Outlook…?

Or maybe it does and I just don't know yet... I get emails on a regular basis that I need to turn into appointments.  Why isn't there a feature to create a new appointment or task based on an email? 

Read More »

MVP for another year

This morning I got a nice email from Microsoft to let me know that I was awarded the Microsoft MVP award for my third year.  I'm pretty flattered to be awarded again, and already planning the trip to the MVP

Read More »

Disable the Excel Compatibility Checker

I've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid

Read More »

Break All Links In An Excel Workbook

Macro Purpose: This code quickly replaces all external links in an Excel workbook with their values. It is something that can be very handy when you need to send a heavily linked workbook outside of your immediate network, to a

Read More »

Converting External Links to Values

I had to do some real quick budgeting work today, and needed to build a template to work from.  The easiest way was to grab a heavily linked workbook we had, and convert all the links to values so that

Read More »

Excel inter-version styles quirk

I found this by accident... I still work between Excel 2007 and Excel 2003 depending on the tasks I'm doing. Reason being is that I find some things easier to navigate, and also have tools built in 2003 that I

Read More »