Hyperlink in Pivot Table

S

Sunryzz

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
 
R

Roger Govier

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.
 
S

Sunryzz

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.
 
Top