Hyperlinks in a Pivot Table - can this be done

[Ellen]

I have someone who wants Hyperlinks to be active in a Pivot Table. It
doesn't look like this is possible and I want to verify that active
hyperlinks cannot be put in a Pivot Table. Until I can find a definite
answer, he won't accept this is not possible. If this can be done, what
needs to be done so they are active. He wants the links to go to other areas
of the workbook. We are using Excel 2003.

 

[Debra Dalgleish]

No, hyperlinks can't be put in a pivot table.
You could use programming to select a different area in the workbook if
a cell with a specific value is clicked. For example, this code would go
on the worksheet module where the pivot table is located.

Right-click on the sheet tab, and click on View Code, then paste in this
code. Modify it to meet your workbook setup.

'==================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then GoTo exitHandler

Select Case Target.Value
Case "www.sample1.com"
With Worksheets("Sheet1")
.Activate
.Range("B5").Select
End With
Case "www.sample2.com"
With Worksheets("Sheet2")
.Activate
.Range("C10").Select
End With
Case Else
'do nothing
End Select

exitHandler:
Exit Sub

End Sub
'=====================