Pivot table + hyperlink
Solved/Closed
ln1605
-
baladur13 Posted messages 47561 Registration date Status Modérateur Last intervention -
baladur13 Posted messages 47561 Registration date Status Modérateur Last intervention -
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 réponses
Hello 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)]
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)]
Hello
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...!!!!
________ ___. .__ \______ \ ____ __ _\_ |__ | | ____ ____ | | \ / _ \| | \ __ \| | / _ \ / \ | ' ( <_> ) | / \_\ \ |_( <_> ) | \ /_______ /\____/|____/|___ /____/\____/|___| / \/ \/ \/
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...!!!!
