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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ShowDetail on PivotTable does not work in VBA 0
Adding Sheets with names from a list. 2
Get info from a file that is already open 3
Dynamic PivotTable source - limit sources 1
How to maintain dynamic data range for Excel PivotTable 4
Nested With's 2
Sheets won't move 7
trouble getting addin's workbook_open procedure to recognize activeworkbook 6

Back
Top