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…


SP3 for Office 2007 is released, plus some important information about the August/October 2011 CUs.

On October 25, Microsoft released Microsoft Office 2007 Service Pack 3. KB Article 2591039 (http://support.microsoft.com/kb/2591039) contains technical details about SP3, while 2526086 (http://support.microsoft.com/kb/2526086) contains general information. Because Office service packs are cumulative, you do not have to install Service Pack 1 or Service Pack 2 before you install Service Pack 3. Service Pack 3 includes all…


Chart only plots one data point after installing MS11-072

In addition to the two other side effects to installing MS11-072 (http://support.microsoft.com/kb/2553091) , as mentioned in the previous blog, there is yet another issue – this time with charts. Mind you this problem doesn’t happen with all charts, but with some charts you will see the horizontal axis is no longer being plotted as separate…