need help-excel 2003 hyperlink in pivot

[ConfusedNAccess]

is it possible at all to have an active hyperlink in excel 2003??? i can not find anything anywhere.. completely frustrated.. my purpose is to open a word document from the excel pivot table.. the document associated with whatever corresponding cell...

i know there is a miracle worker out here in tech land that is a wizard at this stuff.. please help if you can.

thanks

 

[pbrodsky]

I really don't think there is any such built-in feature, and from your description it is not clear how a pivot table fits in.

If you describe what you are trying to do, there is probably some way to program it.

 

[ConfusedNAccess]

Thank you for your response to my issue. As a novice to all this I will try to do my best in explaining the steps . .

ok.. so data on sheet1 columns a-g=
a: Name
b: email address
c: phone
d: address
e: state
f: # of claims
g: claim
so when pivot data is grouped on "state", it will show all names and email address associated...(state, name, email, and claim are row data fields and number of claims is a data field --ex. count of # of claims)

I want to be able to click on "claim" and open the claim in word document. the hyperlink exists in column g on the sheet1 and I can currently click on the hyperlink and successfully open the document, however I lose this function when organizing my data in a pivot table sheet1 range a1:g500 how come this feature is disabled in pivot view??

I trust that these details may be somewhat helpful in attempts to resolve this. I certainly appreciate all the help I can receive from those more technical experts than myself.

Again, thank you in advance for all your assistance with this frustrating problem.

 

[SkipVought]

Hi,

There is no built-in functionality for this in a PT. A PT is just data.

If you care to pursue a VBA code solution, based on the Selection Change event, please repost your question in Forum707.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]