How do I Use the Hyperlink Function to link to a Pivot Chart Tab?

[zenchaotik]

I'm a longer time reader, first time poster. I am creating a "table o
contents" worksheet with hyperlinks to various other worksheets in m
workbook. The problem is I am unable figure out how to hyperlink to
PivotChart. It is a Pivot Chart on it's own tab... not embedded i
another worksheet (if that makes sense).

While I could change the location of the PivotChart to a differen
worksheet, I would prefer to simply link directly to it. Any ideas o
how to get the hyperlink function to link to that PivotChart?

Thanks for any input. :

 

[Dave Peterson]

Jon Peltier has a workaround that you might be able to use at:
http://peltiertech.com/Excel/Hyperlinks.html

(look for: Hyperlink to a Chart Sheet)