Display the MDX query of an Excel 2007 PivotTable (By Marco Russo)
Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Marco Russo here provides file with code that allows to right mouse click on pivot table and then choose "Show MDX". Very useful.