Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks in a Pivot Table - can this be done
I have someone who wants Hyperlinks to be active in a Pivot Table. It
doesn't look like this is possible and I want to verify that active hyperlinks cannot be put in a Pivot Table. Until I can find a definite answer, he won't accept this is not possible. If this can be done, what needs to be done so they are active. He wants the links to go to other areas of the workbook. We are using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks in a Pivot Table - can this be done
No, hyperlinks can't be put in a pivot table.
You could use programming to select a different area in the workbook if a cell with a specific value is clicked. For example, this code would go on the worksheet module where the pivot table is located. Right-click on the sheet tab, and click on View Code, then paste in this code. Modify it to meet your workbook setup. '================== Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count 1 Then GoTo exitHandler Select Case Target.Value Case "www.sample1.com" With Worksheets("Sheet1") .Activate .Range("B5").Select End With Case "www.sample2.com" With Worksheets("Sheet2") .Activate .Range("C10").Select End With Case Else 'do nothing End Select exitHandler: Exit Sub End Sub '===================== Ellen wrote: I have someone who wants Hyperlinks to be active in a Pivot Table. It doesn't look like this is possible and I want to verify that active hyperlinks cannot be put in a Pivot Table. Until I can find a definite answer, he won't accept this is not possible. If this can be done, what needs to be done so they are active. He wants the links to go to other areas of the workbook. We are using Excel 2003. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks in pivot table | Excel Discussion (Misc queries) | |||
How do I transfer data with hyperlinks to a pivot table without l. | Excel Worksheet Functions | |||
Pivot Table - Filter - Hyperlinks? | Excel Discussion (Misc queries) | |||
pivot table + explorer + hyperlinks | Excel Discussion (Misc queries) | |||
pivot table and hyperlinks | Excel Discussion (Misc queries) |