Share via

Hyperlink in a pivot table data source but "show details" only shows display name

Anonymous
2011-06-10T05:33:33+00:00

Is there a way configure the show details view of a pivot table to preserve the hyperlink field attributes. The hyperlink field in a pivot table data source is shown with display value only in the show details view.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-07-06T12:57:08+00:00

    Is there a way configure the show details view of a pivot table to preserve the hyperlink field attributes. The hyperlink field in a pivot table data source is shown with display value only in the show details view.

    Furrthermore,  If you pivot a table where one of the collumns  has a =HYPERLINK()  function you loose the link properties of thecells in that collumn . Only the display name appears.  Is there a way to preserve the HYPELINK properies , so one can analize a pivot and drill down occasionally through the HYPELINK ?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-06-10T21:18:12+00:00

    Provide more information with sample data, Upload sample data to the public SkyDrive folder and provide us the link so that we can assist you better.

    Refer the link below to upload the screen shot to the sky drive:

    http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65

    Was this answer helpful?

    0 comments