Hyperlink in Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Export Pivot table 1
Consolidate Pivot Tables/Cache using Excel 2003 1
Pivot table report invalid 0
How to base a pivot table on another pivot table? 3
Excel 2010 Slicer Connection / Pivot Table Problem 3
pivot tables in multiple workbooks using one datasheet? 3
making an excel table visible for external data on pivot table 1

Back
Top