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
With my new Windows Mobile phone came Office Mobile, including Excel Mobile version 6.1. (I always thought it was Pocket Office and Pocket Excel, but my phone says otherwise.) Being an Excel guy, I was kind of excited to see
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.
