Pivot Table Format from Source Data

T

tommcbrny

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
 

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

Excel does not accept text format! 0
Write back from pivot table 1
Write back from pivot table 0
Excel 2007 pivot table using analysis services cube as data source 0
Formula to Look up values from a pivot table 1
Embed the same Excel multiple times 0
Pivot Table Page Break Refresh Problem 0
VLOOKUP a Pivot Table Filter 0

Top