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)