PivotTable made from a table in a Sharepoint excel document as the source. Source table has a column with hyperlinks that I want maintained in the pivot table. VBA code suggested to do this was:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Update 20140814
If Target.Cells.Count <> 1 Then Exit Sub
On Error Resume Next
Application.ActiveWorkbook.FollowHyperlink Address:=CStr(Target.Value), NewWindow:=True
End Sub

But this made every cell in the pivot table sheet generically hyperlinked to the sharepoint source document. I'm unfamiliar with VBA code, can I adapt the syntax to target only the cells with hyperlinks. If so, I also dont want the targeted cells to just link generally to the sharepoint source document, but to the external websites they're connected to in the source document.

To note: most data in the pivot table is text not count/numerical, meaning isolation of text strings to target hyperlinks won't work like in this code.

Thanks in advance