How do I transfer data with hyperlinks to a pivot table without l.

  • Thread starter Thread starter DarcyMS
  • Start date Start date
D

DarcyMS

I want to take some data from my worksheet and put it into a pivot table so I
can manuever through it easier but when I take a field that has a hyperlink
attached to it and put it in a pivot table the hyperlink functionality
disappears and I can't seem to add it back. Does anyone know how I can
accomplish this? PLEASE HELP!
 
Say the "cold" hyperlinks appear in column G starting in G20. They are not
"clcikable". In H20, enter:

=hyperlink(G20) and copy down

this will produce a nice list of "clickable" hyperlinks
 
Back
Top