Pivot Table totals

[Browny]

I discovered a neat trick in a pivot table. When i double click on the total
cell, it opens up another worksheet (sheet2) and expands the data, but it
opens a new worksheet each time(sheet3, sheet4 etc). Can i have it open in
the same sheet each time. I'd like to use the data to form the basis of a
standard letter and drop the data in the same spot each time.

 

[Ian Grega]

Browny I doubt that is possible.
The "trick" also works for all cells in Pivot Tables not just the total cell.