?Active hyperlink in pivot table?

S

slaya_cz

Hello

is it possible to display in the pivot table active hyper link?
For example
I have database with these columns
Name, Web, Month, Salary

When there are
Rows
Name, Web
Column
Month
Data
Salary

is it possible that I can see the web information (i.e. www.data.xyz)
and when I click on that (into the pivot table), it will launch
Internet Explorer with this page?

Thanks a lot

Regards
Pavel
 
D

Dave Peterson

If you're trying to add a link to a cell in a pivottable, it sure looks as
though Insert|hyperlink is unavailable.

And if your data contained the links, then this link is lost when you created
the pivottable.

Maybe you can use an adjacent cell with a formula like:

=hyperlink(a7)

(if a7 contained a valid URL)
 
Top