Question Locked

How to keep Hyperlinks in the results from a Pivottable

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I use a PivotTable to track orders. The sheet that has the Data has a Hyperlink for each order# to take you to that order. but the results from the output from the Excel PivotTable remove that Hyperlink. Is there a way to get the PivotTable to keep the Hyperlinks?

Thanks,

Stu

2 replies

by Former member

Unlike external data ranges, active hyperlinks are not supported in PivotTable cells. The hyperlink is treated as text, but you cannot follow the hyperlink to a Web page or document, in Excel or Excel Services.
http://office.microsoft.com/en-us/excel/HA102079791033.aspx

Please post back if you have any more problems or questions.

This discussion is closed to new replies.