Hi,

I import data via web query to a worksheet then create a pivot table from
that data. When imported, some of the data is an HTML link (to a ticketing
system). The ticket number, for example, is also a link that when clicked on
will take you to the ticket via web browser.

Is it possible to maintain this formatting for the data as it appears in the
pivot table? I would like to be able to click the ticket number in the pivot
table, for instance, and be taken to a browser to access the ticketing system.

Thank you,
Tom