pivot table in excel 2000

  • Thread starter Thread starter shiepowk
  • Start date Start date
S

shiepowk

Is there any way that I can create a hyperlink inside a pivot table?

Thank you kindl
 
I don't think so.

I tried creating a pivottable and selected a cell, then Insert from the menubar.

Insert|Hyperlink was disabled.
 
A pivot table doesn't support hyperlinks.
You could use the SelectionChange event to follow a hyperlink on a
different worksheet. For example:

Private Sub Worksheet_SelectionChange _
(ByVal Target As Range)
If Target.Value = "Smith" Then
Sheets("Lists").Range("E4") _
.Hyperlinks(1).Follow
End If
End Sub
 
Back
Top