Pivot table + hyperlink
Solved/Closed
Hello,
After spending 2 hours searching by myself, I finally decided to ask the experts!
So, I actually created a table to list files and their location (hyperlink), so we can easily find them later.
From this table, on another sheet, I created a pivot table that acts as the search tool: a person can then search for a file on a specific theme, from a specific year... the names of the corresponding files are displayed along with their location, but the problem is that the location, which is actually the hyperlink entered in the other table, is no longer active in this pivot table!
I would like this link to be active so that users only have to click on it!
Thank you in advance for your help!!
Configuration: Windows XP / Internet Explorer 8.0
After spending 2 hours searching by myself, I finally decided to ask the experts!
So, I actually created a table to list files and their location (hyperlink), so we can easily find them later.
From this table, on another sheet, I created a pivot table that acts as the search tool: a person can then search for a file on a specific theme, from a specific year... the names of the corresponding files are displayed along with their location, but the problem is that the location, which is actually the hyperlink entered in the other table, is no longer active in this pivot table!
I would like this link to be active so that users only have to click on it!
Thank you in advance for your help!!
Configuration: Windows XP / Internet Explorer 8.0
3 answers
-
ContributorHello forum
Excel pivot table reports do not support hyperlinks. Only the text of the hyperlinks from pivot table lists appears in Excel.
Mytå
--
What a claim to say that computing is recent
Adam and Eve already had an Apple! [MsProject 2003(FR), Excel 2003-2007(FR)] -
ModeratorHello
________ ___. .__ \______ \ ____ __ _\_ |__ | | ____ ____ | | \ / _ \| | \ __ \| | / _ \ / \ | ' ( <_> ) | / \_\ \ |_( <_> ) | \ /_______ /\____/|____/|___ /____/\____/|___| / \/ \/ \/
The continuation here: https://forums.commentcamarche.net/forum/affich-22325748-svp-liens-hypertext-dans-tableau-pivot
--
Very difficult to catch a black cat in a dark room
Especially when it isn't there...!!!! -
Hi,
There's no need to create other discussions on the same topic. Just put "up" in this first discussion (which explains your problem well) to bring it back to the top of the office forum list.
