clickable hyperlinks in pivot tables

[fatsi]

Hello everybody, I have tried to apply thise macro on my sheet but there is a problem, hyperlinks are active in some cells not in all cells. I am not really good at macro so I couldn't figure out what is the problem. The yellow cells contain hyperlinks in data sheet but when I click on the cell it goes to data sheet not to the hyperlink, and hyperlinks work in the white cells. Could you please help me? You can find file attached.. Thank you very much... :D