How to keep Hyperlinks in the results from a Pivottable

by proudtexan . Updated 17 years, 11 months ago

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,