Chris Webb wrote this post: Binding an Excel table to the results of an MDX query. In a comment at the bottom, Scott Gall suggested using VBA. I want to take this one step further to allow custom MDX to be filtered by the filters from the Pivot Table Field List, while not actually using a pivot table (similarly to formulas mode).
This provides the following benefits over (or in addition to) pivot tables/formulas mode …
This Excel file does the above. Things to note …