Hyperlink sheet or document within generated Pivot Table

[HYSC84]

https://www.extendoffice.com/documents/excel/1961-excel-pivot-table-display-hyperlink.html

Something similar with the above but links for sheet or document within the workbook

When double click the pivot table line, another sheet of source data is created.

From there i want to have the hyperlink. Right now the link is there but not clickable

 

[AFPathfinder]

If I'm not mistaken, the pivot table saves a static copy of the dataset and that is what you see when you double click (evident by the refresh functionality). It takes the values of the cells and not the formulas which is why the hyperlinks are getting unlinked. The only solution I can think of for this is VBA on event or button press using a formula to identify the hyperlink in the original dataset to re-establish it in the temp static dataset.

 

[HYSC84]

If I'm not mistaken, the pivot table saves a static copy of the dataset and that is what you see when you double click (evident by the refresh functionality). It takes the values of the cells and not the formulas which is why the hyperlinks are getting unlinked. The only solution I can think of for this is VBA on event or button press using a formula to identify the hyperlink in the original dataset to re-establish it in the temp static dataset.

Ah, yes was looking for VBA code, as their guides doesnt work. Anyone can help ?

 

[AFPathfinder]

I honestly can't elaborate on a solution since I have no idea what your data looks like, but I'd say look at this kind of logic flow:

Add lookup function to column in temp data set (VLOOKUP, INDEX/MATCH, or VBA manual lookup)
copy/pastespecial values on the lookup values
convert text into hyperlinks

 

[HYSC84]

I honestly can't elaborate on a solution since I have no idea what your data looks like, but I'd say look at this kind of logic flow:

Add lookup function to column in temp data set (VLOOKUP, INDEX/MATCH, or VBA manual lookup)
copy/pastespecial values on the lookup values
convert text into hyperlinks

Your earlier sentence - The only solution I can think of for this is VBA on event or button press using a formula to identify the hyperlink in the original dataset to re-establish it in the temp static dataset.


This is the solution I'm looking for with VBA, as doing another round of linking in the temp static dataset is not prefer because my data may change. I already putting the clickable link inside the original source but become broken when retrieve from the temp static dataset

 

[AFPathfinder]

What part of the VBA are you having problems with?