Forum Discussion
Hyperlink an internal document in a pivot table
I am having some trouble with trying to create a hyperlink in a pivot table. The problem is that its an internal document instead of a http: link. I potientially found a round about way with putting a smaller table beside the pivot table but I am having trouble linking the table to the pivot table. I did create all the connections I need in Power Pivot but no luck. What I am trying to do is create a dashboard that highlights certain objects and allow the end user to also click on a specific hyperlink that would pull have a folder that would have pictures in it. Is there a way to get around this without using a macro or would I have to use a macro. Please let me know I am also running Excel 2016.
Thank you
6 Replies
- Here is an example file with a hyperlink in pivot ... I had it in my archive ... I don't know where I got it from ... but thanks to the donor ... if you can help.
If I could help with that, I would appreciate a short feedback.
Nikolino
I know I don't know anything (Socrates)I can get the hyperlinks in the tables but I can't get the hyperlinks to work in a pivot table.
- Can you post a screen-shot of what you have so we might have an idea? Even better, can you post a (dummy) workbook with the same layout but nonsense data?
What Nikolino posted is what I am doing but the Pivot Table itself will not hyperlink too internal folders/files. The next step for me will be combining different workbooks into one workbook while still being able to hyperlink a certain column to those internal folders/files.
- Unfortunately I can not help here .... I had the file in the archive and sent it because it might be useful .... but with pivot I can not help much.
Wish you success in your project and hopefully there is someone who knows a lot more than I do and who can help above all.
Nikolino
