Share via

drill down in pivot table with hyperlink in source data

Anonymous
2011-03-07T14:51:37+00:00

I created a pivot table from a data table that has hyperlinks to source documents. Is there a way when you're drilling down to have the hyperlinks appear so that you can drill down to these source documents?

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-04-05T11:39:28+00:00

    AFAIK this is not possible, excel does not have the control on displaying

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-03-11T14:07:52+00:00

    If I click on a hyperlink, which is displayed as text in the underlying data table, the source file opens . However, the question is how to get these hyperlinks to show up in the tab that opens showing the detail of the amount you're drilling down on?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-03-08T07:04:50+00:00

    Do you want the source file to open when you click on hyperlinks?

    Are the hyperlinks displayed as text?

    Was this answer helpful?

    0 comments