Pivot Table Drill down

[rhefel]

Is there a way for the drill down data to retain its Hyperlink. When I
drill down on the Pivot Table I would like the original Hyperlink
status from the source data to be retained.

 

[BrianB]

Don't understand your problem here. Excel automatically retains the lin
to external data so you can use menu 'Refresh' to update the table a
any time - assuming the source is in the same place as before..

If you want to move a source file elsewhere, open the one with th
pivot table first and use File/Copy, when the link will automaticall
change (if you also save the file containing the PT <<grin>>).

You can use Edit/Update links.

There is an option to "Save data with table layout"

 

[rhefel]

What I would like to happen is when you drill down on the pivot table i
for the detail items which are diaplayed on the just created sheet t
retain the hyperlink ability. What happens now is the detail ite
displays the Hyperlink description but is not active