Pivot Table. (VBA needed)

[Sanzens]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Potassium[/TD]
[TD]Vegetables[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Fruit[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi all.

So, I have a Portfolio in a Pivot Table. I need help with the last item of each of my cascades. In this example the item is the cell "Banana". I want to insert an object on the last cell of each cascade, more precisely, another excel file. However, excel does not allow me to do it.

Can someone with VBA knowledge give me a code that I can apply to all last cells of each of my cascades in order to hyperlink different excel files?

The final aim is to double click "Banana" cell and it would open a related excel file.

Thank you!

Cheers!