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

  1.
    m@rina Posted messages 27782 Registration date   Status Moderator Last intervention   11 568
     
    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
  2. 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
  3. m@rina Posted messages 27782 Registration date   Status Moderator Last intervention   11 568
     
    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
    1. marionh
       
      Thank you very much for your response,

      Marionh
      0