pivot table must be hyperlinked to internal files

[Joy888]

Hi, please help me with the code. The P.O. no in my pivot table must be hyperlinked to internal files (e.g PDF.)

 

[p45cal]

You won't get true hyperlinks in a pivot table.
But you can do this:

Excel Hyperlinks and Hyperlink Function Step-by-Step Guide

Quick trick for Excel hyperlinks, easy HYPERLINK function examples. Hyperlink table of contents, or remove all hyperlinks. Excel hyperlink security warning

www.contextures.com

You will need to adapt the following already adapted code from that link to suit yourself:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim selPF As PivotField, strField As String, strAdd As String, myVal As String

strField = "P.O.  NO."
On Error Resume Next
Set selPF = Target.PivotField
If Not selPF Is Nothing Then
  If selPF.Name = strField Then
    myVal = Target.Value
    If Len(myVal) > 0 Then ThisWorkbook.FollowHyperlink Address:="C:\Users\blah\Documents\" & myVal & ".pdf", NewWindow:=True
  End If
End If
End Sub

 

[Joy888]

Hi, Thank you so much for your reply. I tried the code but it didn't work for me.
I'm sorry Im not good with coding. Hope you can help me. The P.O No. on the Source sheet is link to a pdf file and on the pivot table I want to create a fake hyperlink so that everytime I click the P.O No. the particular pdf file will open.

 

[p45cal]

try the attached.

 

[Joy888]

Wow Thank you so much it's now working...