PivotTable ShowDetail not into ActiveWorkbook

  • Thread starter Thread starter baldmosher
  • Start date Start date
B

baldmosher

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