Hyperlinks in Pivot table.

Hi experts,

Im trying to get Hyperlinks to work in Pivot table. I get it to work with A VBA, but i need it to work with hyperlinks that have had their name change.
Does anyone have a solution for this or is this not possible..

Thanks in advance!

Hi,

The hyperlinks do not change names, I change them my self, so for example a hyperlink for www.google.com will become "search".
I can make hyperlinks to work if the name is www.google.com, but I can not get it to work if I change the name to "search". I have a Pivot table with lot of hyperlinks all with "changed" names.
The hyperlinks in my table are links to documents in a database.

Hope I cleared things

Hi,

I put an example here, its smaller and easy to understand than my original.

You can see a table with hyperlinks that work, with names that are changed a names that are unchanged. In the Pivot table you see the same I also have VBA code that makes the Hyperlinks work in the Pivot table. Now I just need to get the links with their name changed to work.

Hi noboffinme,

Thank you, yes I was hoping someone already had this problem and had solution, Im not that experienced in VBA coding.

But thanks for trying!

You may adapt this code to your ranges:

Please Login or Register  to view this content.

Hi Izandol,

Nice, this works great, I can get it to work perfectly! If my pivot is on another sheet, I have to modify the range but cant get it to work, how should the code look if I have my table on sheet 2 and my pivot on sheet 1?
Thanks for your help!!

You must change:

Please Login or Register  to view this content.

Thank you!

Saved me a lot of trouble! Now my sheet works great!

Have a merry christmas!

You are welcome. Merry Christmas!

I have a similar question.
I have made a normal table where there are hyperlinks to other tabs of my excel file (so not to external internet websites)
In the pivot table that is based on this table, I want to activate these hyperlinks. I have searched on the internet, but all the codes that are given are for external websites.

Could you help me to give me advice on how to create a code to activite hyperlinks to other tabs in a pivot table?

I created an excel to show what I want to create. So in the pivot table on the first tab, I want to have hyperlinks, if I click on "2010", I want to be directed to the tab "2010"

Thank you in advance