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.