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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I transfer data with hyperlinks to a pivot table without l. (https://www.excelbanter.com/excel-worksheet-functions/174159-how-do-i-transfer-data-hyperlinks-pivot-table-without-l.html)

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

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!

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

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
--
Gary''s Student - gsnu200766

"DarcyMS" wrote:

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!