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.