Hi all,
I used this VBA in order to put URL in PivotTable:
https://www.youtube.com/watch?v=38wRYPEpJxY
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim selPF As PivotField
Dim strField As String
strField = "link"
On Error Resume Next
Set selPF = Target.PivotField
If Not selPF Is Nothing Then
If selPF.Name = strField Then
ThisWorkbook.FollowHyperlink _
Address:=Target.Value, NewWindow:=True
End If
End If
End Sub
the problem is that in some version, excel changes "#" to "%20-%20", thus the URL is not correct and causing an error.
Any thoughts why?
Thanks.
Bookmarks