Pivot Table

[Eric]

I was just wondering if someone knew whether or not a
Pivot Table could display its results as hyperlinks?
I have a pivot table that is linked to quotes in a file
and I use the Pivot Table as a kind of search to locate
quotes by number. Is there a way to make the Quote
numbers in the Pivot Table become hyperlinks to the Saved
Quotes? (The Saved Quotes are saved by quote number also.)

 

[Tom Ogilvy]

I doubt it, but if you can figure out a formula that will convert the quote
number produced by the pivot table into the location of the Saved Quotes you
could use the Hyperlinks worksheet function formula to build your link.
This would be in a cell outside the pivot table, but adjacent to it with
reference back to the quote produced by the pivot table.

 

[Guest]

Well, I got a formula to produce hyperlinks when the
Pivot Table query is executed, but I was wondering if
there is a code that I can attach to the table so that
when a field setting is changed, my values in the cells
change with it?

Range("C14").Select
Dim MyName1 As String
MyName1 = Range("A14").Value
With Worksheets(5)
.Hyperlinks.Add .Range
("C14"), "\\ERIC\SharedDocs\Shared Documents
Eric&Rick&Tom\Quote System Database\Saved Quotes\" &
MyName1 & ".xls", TextToDisplay:=MyName1

Above is the coding I created, is there anyway to add
something that would tell it to re-run if a change is
made to the Pivot Table? Thnaks!

 

[Tom Ogilvy]

Well, that isn't a formula. With a formula using the hyperlink worksheet
function, it would update automatically.

A hyperlink worksheet function would be placed in the cell like

=HYPERLINK("\\ERIC\SharedDocs\Shared Documents Eric&Rick&Tom\Quote System
Database\Saved Quotes\" & A14 & ".xls", A14)