Hi,

I have a pivot table with accounting data.(OLAP)

What I would like is a macro that can grab the query when user performs a drill down on a cell in the pivot and reuse this data which I understand is a mdx query to a new query against a SQL server for details that is not stored in the pivot table, in a separate sheet.

Is this possible ?

Lars