This is one of my favourite Excel add-ins when dealing with Analysis Services cubes. It can pull the MDX out of a pivot table, search cubes, add in calculated measures on the fly, and allow users to share measures.
The latest releases fix some bugs and provide a very useful feature of clearing a pivot table’s cache. The pivot table cache, a monstrosity of XML code, is known to blow up many an Excel workbook.
Show properties as a caption allows captions to be exposed as real members in the workbook.
Worth downloading if you use OLAP cubes regularly.