PIVOT TABLE + HYPELINK: Mission Impossible ?
 

IN PIVOT TABLE, I WANT ONE OF THE ROW FIELDS TO BECOME ALL HYPERLINK. IS
THIS POSSIBLE ??

ALSO CAN WE MAKE THE VALUES HYPERLINK TOO ??


Example, the role field is fruits. Page field is country.
For US, we have orange, apple. For UK we have pears and lemon.
The fruits need to be hyperlinked. Eg apple is underlined and hyperlinked
and when users select US, both apple and orange are clickable and when users
click on apple it takes him to the page describing what apple is (of course
in reality it is not apple but something else).

Hi hkappleorange,

You might try using a worksheet change event to select a range
based on the row field data.

Something like this will work if you set ranges named 'apple' etc
in the workbook. Put the code in the code page for the worksheet
that holds your pivot table.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' change the column no that of the pivot table row field
If Target.Column = 1 Then
' select a range named same as row field value
Range(Target.Value).Select
End If
End Sub

You may need to include a bit of error trapping :^)

Ed Ferrero
http://edferrero.m6.net/

THIS POSSIBLE ??

ALSO CAN WE MAKE THE VALUES HYPERLINK TOO ??


Example, the role field is fruits. Page field is country.
For US, we have orange, apple. For UK we have pears and lemon.
The fruits need to be hyperlinked. Eg apple is underlined and hyperlinked
and when users select US, both apple and orange are clickable and when
users
click on apple it takes him to the page describing what apple is (of
course
in reality it is not apple but something else).