| description | Various resources related to Excel and PivotTables particularly on top of cubes. |
|---|
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.