PivotTable ShowDetail not into ActiveWorkbook
 

When drilling into a pivot table, can Excel create the datasheet in another
'working document' workbook?

Currently my code is as follows but this just seems one step too many.

Set WB = Workbooks("working.xls")
rng.ShowDetail = True
ActiveSheet.Move After:=WB.Sheets(WB.Sheets.Count)

PivotTable ShowDetail not into ActiveWorkbook
 

i don't think so.
your method is what I'd go with.

"baldmosher" wrote in message
...
When drilling into a pivot table, can Excel create the datasheet in
another
'working document' workbook?

Currently my code is as follows but this just seems one step too many.

Set WB = Workbooks("working.xls")
rng.ShowDetail = True
ActiveSheet.Move After:=WB.Sheets(WB.Sheets.Count)