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)
|