You could use the worksheet's Before_DoubleClick event to activate a
cell in the other pivot table. For example:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Sheets("Data").Activate
Sheets("Data").Range("A3").Activate
End Sub


Dineshnewcommer wrote:
Hi,
I have a situation where I need a pivot dirll down to take the uses to
another pivot instead of the underlying data. can any one suggest how this
can be done.

Thanks
Dinesh


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html