How To: Writing Index, Match and Index, Match, Match formulas

Writing a formula in Excel can be tricky, especially if you plan on writing one that has a bit of length to it and the INDEX and MATCH functions are no exception. There are a couple of things to keep in mind when writing formulas that will make it much simpler. Consider the following data:   …


The Long Road: Problems with hyperlinking Office Documents in Excel

When you create a hyperlink to another Office document in Excel 2007 or 2010 and click to follow that hyperlink, you expect the document to open. In some cases, however, you may receive an error: “Cannot locate the Internet server or proxy server”. A quick BING search reveals KB Article 218153 (http://support.microsoft.com/kb/218153). This article directs…


Excel Crashing? Look at your COM add-ins first.

More than likely you or someone you know has experienced the pain and annoyance that is when Excel crashes. There is nothing more annoying than working in your spreadsheet, making good progress, when bam! The worksheet crashes. And while there can be multiple reasons for Excel crashing on you, the most common cause is the…


How To: Show pivot table data in flat format

As a seasoned Excel user, you are no doubt familiar with Pivot Tables and how they work. (If not, here’s a great place to get started on them: http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx). Perhaps you’ve wanted to see your pivot table data differently. We know how to pivot the tables to display our data as needed, but what if…


October 2011 Cumulative Updates for Excel 2007 have been recalled

The hotfixes for the following updates as part of the October 2011 CU have been recalled. Two critical fixes that were supposed to be part of this CU were missing. The following hotfixes have been recalled: http://support.microsoft.com/kb/2596535 http://support.microsoft.com/kb/2596538 http://support.microsoft.com/kb/2596539 http://support.microsoft.com/kb/2596545 These updates will be be-issued as soon as possible.  


Excel 2010 – ActiveX controls resize or shift during or after print preview

Here’s an interesting scenario. You have an Excel 2010 spreadsheet that contains multiple activeX controls. After you do a print preview of the spreadsheet and save the sheet, close it and re-open it you notice that some or all of the ActiveX controls are resized. They have either gotten smaller or larger, or have shifted left…


How to: Automatically format Excel’s track changes to look like Microsoft Word’s track changes feature

If you have ever used the “Track Changes” feature in Microsoft Word, then you know that the changes you make aren’t deleted, but they are shown with a strikethrough and typically highlighted in red. If you have used the track changes feature of Excel, then you know that the Track Changes feature in Excel and…


October 2011 Cumulative Updates released

The Cumulative Updates (CUs) for October 2011 have been released. Here is a breakdown of the CUs released for Excel. KB article 2596535 (http://support.microsoft.com/kb/2596535) – You have a Word document that contains a text box and a picture. The text box overlays the picture. When you use a computer that has the 2007 Microsoft Office…