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

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!
 
G

Gary''s Student

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
 

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

Retain pivot table formatting after refreshing data 0
Pivot Table and Merged Cells Help 1
pivot 0
Formula to Look up values from a pivot table 1
Pivot table data source 1
Adding data to a 2007 pivot table 2
Changing pivot table ADO recordset 0
Pivot Tables- SQL Alias' & Field Lists 1

Top