This blog/add-in is a really useful tool for troubleshooting cube issues within Excel.

http://ssasbysss.blogspot.co.uk/2011/02/mdx-extraction-of-excel-pivot-table.html