Hyperlinking in a Pivot Table
So one of the row or column or page fields is a hyperlink in the raw data?
If yes, then the "hyperlinkness" is lost when the pivottable is built.
If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:
=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)
Longtime listener first time caller wrote:
Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.
Is there any solution to this or some way around it?
Thanks for your time.
--
Dave Peterson
|