Hyperlink in a Pivot Table
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.
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
-
ModeratorHello,
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 -
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. -
ModeratorHello 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
