Hyperlinks in Excel Pivots?

[Karthik-Excelsior]

Hi Excel Gurus

My Pivot table raw data has hyperlinks for certain entries. However, the Pivot table doesn't display them as hyperlinks, which is a bummer!

Any idea, how I can retain the Hyperlinks in the pivot as well ? If that's not an option with the pivot, would really be helpful, if you can suggest a workaround to it as well!

Thanks much in advance!

 

[circledchicken]

Hi,

I'm not sure its possible to enable them within a PivotTable. Possible workarounds might be:

• Use a HYPERLINK formula outside the PivotTable: MS Excel: HYPERLINK Function (WS)
• Use a VBA solution, as described here: Follow hyperlinks in a pivot table | Get Digital Help - Microsoft Excel resource