Hyperlink in Pivot Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sunryzz - 27 Jan 2006 21:07 GMT

Is it possible to put hyperlinks into a pivot table to go to the detail in
other worksheets? I have a top 10 list of components with issues and would
like the user to be able to click on the component to go to the list of
issues. I thought if I put the hyperlink in the cell where the pivot table
is getting it's info, it would come through, but that didn't work. Any
suggestions?

Thanks

Reply to this Message

Roger Govier - 27 Jan 2006 22:19 GMT

Hi

Just double clicking on the cell with the data of interest, will open
another sheet showing all of the entries making up that value.
Delete the newly created sheet after you have finished with it.

Signature

Regards

Roger Govier

> Is it possible to put hyperlinks into a pivot table to go to the
> detail in
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

Sunryzz - 30 Jan 2006 16:20 GMT

Would you have any suggestions if the data of interest is actually not in the
same range that is included in the pivot table? I have 25 separate
spreadsheets with all the detail (no way it would fit in one) and have
hyperlinks to the appropriate worksheet in the range I used for the pivot
table.

> Hi
>
[quoted text clipped - 14 lines]
> >
> > Thanks

Reply to this Message