View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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