How do I use the drillthrough option in Excel PTS?

Hi,

You do not use the drillthrough option directly in Excel PTS.
You must create a VB/ADO macro code.
You must run a drillthrough code on the ADO connection.
f.e.:
DRILLTHROUGH
SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
[Time].[1998].[Q1] ON COLUMNS,
[Product].[All Products].[Drink] ON PAGES,
[Measures].[Units Shipped] ON SECTIONS
FROM [My Cube]

You will get a RecordSet and you will put this result a new sheet.

Peter

"Rico Cali" wrote: