VBA Macro unable to view URL link in Pivot table

Hello Team,

I have seen solutions of VBA scripts that will enable URL links to be viewed in Excel and indeed I have tried them and it worked, but not in my case which I have shared the screenshot.

My Links are not displayed in cells but rather the texts have been referenced to a hyperlink and none of the examples I have seen supports this scenario.

The items in the cells are clickable URLs but cant not be oopened in Pivot table

Grateful if help could come my way.

Thank you

Dniinoi