View original (French)

Hyperlink in a Pivot Table

marionh -  
 marionh -
Hello,

I would like to know if it is possible to insert a hyperlink (allowing me to directly access one of the tabs in the workbook) into a pivot table? If so, how?
Thank you in advance.
Configuration: Windows XP Internet Explorer 7.0

3 answers

Answer 1 / 3
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   11 561
 
Hello,

I don't understand what you want to do... Why put a hyperlink in a pivot table???
You can place it on the second line, for example. It shouldn't be a problem since it will be located between the page field and the pivot table itself.

m@rina
0
Answer 2 / 3
marionh
 
Hello,

Actually, I would like to associate a hyperlink with a value so that when it is displayed and the user clicks on it, it can open a tab in the same spreadsheet.

My problem is that it seems to be difficult to associate a hyperlink in a Pivot Table, perhaps this is due to the fact that the data is variable???

Thank you.

M@rionh.
0
Answer 3 / 3
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   11 561
 
Hello M@rionh

Indeed, this is not possible.

Moreover, this function is an integral part of the PIVOT TABLES... Double click on a value, and you will open a new tab with the details of that value.

m@rina
0
marionh
 
Thank you very much for your response,

Marionh
0