Pivot Table
 

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.)

Pivot Table
 

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.


"Eric" wrote in message
...
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.)

Pivot Table
 

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!

-----Original Message-----
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.


"Eric" wrote in message
...
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.)


.

Pivot Table
 

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)

--
Regards,
Tom Ogilvy

wrote in message
...
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!

-----Original Message-----
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.


"Eric" wrote in message
...
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.)


.