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
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
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
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
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
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
If you're working with the Office 2007 Ribbon, you may have come to the conclusion that there are areas of, the RibbonX object model which are kind of weak. One of the areas that lacks in the RibbonX API is
A user asked a question in Experts Exchange asking if it was possible to use a dynamicMenu in the officeMenu. The answer is that yes, you can, but this person couldn't get it to work. The issue appears to be
I tripped on this in a forum today... The user wanted to create a message for all cells that did not have any cells dependent on their target. The set about doing this by using the Trace Dependents tool through
The last couple of times I've taught, I've received a question about how to deal with the following scenario: You have a table of data, say in A1:A10 In A11, you have the following formula: =sum(A1:A10) Someone highlights row A11,
Over the last couple of weeks, I've led 3 sessions of my course on "Building Spreadsheets That Last". It's a course that focuses on good design practices in Excel, making things easy and intuitive for users, and generally teaches skills
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
