Acknowledgments and Additional Information

Special thanks go to:

• Marco Russo and his post on viewing the MDX behind a PivotTable
• The fantastic Excel team blog. Particularly, this post described how to add private calculated members to a PivotTable was helpful.
• Misha Shneerson and the very helpful blog post about building Excel add-ins for 64-bit Excel.
• This blog post describing a fix for an error message experienced while using an embedded Excel document inside Word.

Additional Resources:

• Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
• Excel Services Compatibility Checker Add-In
• The PivotPower add-in which contains some useful PivotTable extensions. Most of the features are focused on non-OLAP PivotTables, though some of its features are useful with OLAP PivotTables. Particularly, the Reset Captions feature is very handy.
• PTPower is a different free Excel add-in which lets you add calculated members to PivotTables. While not currently as rich in other features, its major plus is a more user-friendly interface for creating the calculations.
• Vivid is a different Excel add-in centered around PivotTables. It is not free, but it has some very impressive features.
• SmartPivot is a different Excel add-in that has a few useful features.