?Active hyperlink in pivot table?

  • Thread starter Thread starter slaya_cz
  • Start date Start date
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
 
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)
 

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

Back
Top