Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

Hi,

Refer to the following information below:

HYPERLINK

Creates a shortcut or jump that opens a document stored on a network server,
an intranet (intranet: A network within an organization that uses Internet
technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can
explore objects, documents, pages, and other destinations on the intranet.),
or the Internet. When you click the cell that contains the HYPERLINK
function, Microsoft Excel opens the file stored at link_location.

Syntax

HYPERLINK(link_location,friendly_name)

Link_location is the path and file name to the document to be opened as
text. Link_location can refer to a place in a document€” such as a specific
cell or named range in an Excel worksheet or workbook, or to a bookmark in a
Microsoft Word document. The path can be to a file stored on a hard disk
drive, or the path can be a universal naming convention (UNC) path on a
server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL
(Uniform Resource Locator (URL): An address that specifies a protocol (such
as HTTP or FTP) and a location of an object, document, World Wide Web page,
or other destination on the Internet or an intranet, for example:
http://www.microsoft.com/.)) path on the Internet or an intranet.

Link_location can be a text string enclosed in quotation marks or a cell
that contains the link as a text string.

If the jump specified in link_location does not exist or cannot be
navigated, an error appears when you click the cell.

Friendly_name is the jump text or numeric value that is displayed in the
cell. Friendly_name is displayed in blue and is underlined. If friendly_name
is omitted, the cell displays the link_location as the jump text.

Friendly_name can be a value, a text string, a name, or a cell that contains
the jump text or value.

If friendly_name returns an error value (for example, #VALUE!), the cell
displays the error instead of the jump text.

Remark

To select a cell that has a hyperlink in it without jumping to the hyperlink
destination, click the cell and hold the mouse button until the cursor
becomes a cross , then release the mouse button.

Examples

The following example opens a worksheet named Budget Report.xls that is
stored on the Internet at the location named example.microsoft.com/report and
displays the text "Click for report":

=HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click
for report")

The following example creates a hyperlink to cell F10 on the worksheet named
Annual in the workbook Budget Report.xls, which is stored on the Internet at
the location named example.microsoft.com/report. The cell on the worksheet
that contains the hyperlink displays the contents of cell D1 as the jump text:

=HYPERLINK("[http://example.microsoft.com/report/budget
report.xls]Annual!F10", D1)

The following example creates a hyperlink to the range named DeptTotal on
the worksheet named First Quarter in the workbook Budget Report.xls, which is
stored on the Internet at the location named example.microsoft.com/report.
The cell on the worksheet that contains the hyperlink displays the text
"Click to see First Quarter Department Total":

=HYPERLINK("[http://example.microsoft.com/report/budget report.xls]First
Quarter!DeptTotal", "Click to see First Quarter Department Total")

To create a hyperlink to a specific location in a Microsoft Word document,
you must use a bookmark to define the location you want to jump to in the
document. The following example creates a hyperlink to the bookmark named
QrtlyProfits in the document named Annual Report.doc located at
example.microsoft.com:

=HYPERLINK("[http://example.microsoft.com/Annual Report.doc]QrtlyProfits",
"Quarterly Profit Report")

In Excel for Windows, the following example displays the contents of cell D5
as the jump text in the cell and opens the file named 1stqtr.xls, which is
stored on the server named FINANCE in the Statements share. This example uses
a UNC path:

=HYPERLINK("\\FINANCE\Statements\1stqtr.xls", D5)

The following example opens the file 1stqtr.xls in Excel for Windows that is
stored in a directory named Finance on drive D, and displays the numeric
value stored in cell H10:

=HYPERLINK("D:\FINANCE\1stqtr.xls", H10)

In Excel for Windows, the following example creates a hyperlink to the area
named Totals in another (external) workbook, Mybook.xls:

=HYPERLINK("[C:\My Documents\Mybook.xls]Totals")

In Microsoft Excel for the Macintosh, the following example displays "Click
here" in the cell and opens the file named First Quarter that is stored in a
folder named Budget Reports on the hard drive named Macintosh HD:

=HYPERLINK("Macintosh HD:Budget Reports:First Quarter", "Click here")

You can create hyperlinks within a worksheet to jump from one cell to
another cell. For example, if the active worksheet is the sheet named June in
the workbook named Budget, the following formula creates a hyperlink to cell
E56. The link text itself is the value in cell E56.

=HYPERLINK("[Budget]June!E56", E56)

To jump to a different sheet in the same workbook, change the name of the
sheet in the link. In the previous example, to create a link to cell E56 on
the September sheet, change the word "June" to "September."

Challa Prabhu

"Longtime listener first time caller" wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson

The value in A3 has to be the address of the link--not the friendly name.

And you're going to have to translate the English =hyperlink() into the language
that you use.

KeepItCool has a translator utility at:
http://members.chello.nl/jvolk/keepitcool/

Longtime listener first time caller wrote:

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson


--

Dave Peterson

OK so I keep my CVs in a folder called candidates and the spreadsheet is in
this candidates folder and all the rest are separated from there based off
what business unit they have interest for (IE accounting, sales, marketing).

So would the address be what I list it as from here? For example Steve Smith
in the sales folder is: Sales/Smith from the location of the spreadsheet or
would it be C:\Candidates\Sales\Smith

and hyperlink needs to be in the language of my version of Excel?

OK I think this is starting to come together, thanks for the help.

"Dave Peterson" wrote:

The value in A3 has to be the address of the link--not the friendly name.

And you're going to have to translate the English =hyperlink() into the language
that you use.

KeepItCool has a translator utility at:
http://members.chello.nl/jvolk/keepitcool/

Longtime listener first time caller wrote:

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson


--

Dave Peterson

Try creating a test formula (in your language) in an empty cell in a brand new
workbook:

=hyperlink("file:////C:\Candidates\Sales\Smith\cv.doc")
(I changed the name of the resume file to cv.doc)

Once you get this test formula working, you'll know what you have to use in the
real workbook.

Longtime listener first time caller wrote:

OK so I keep my CVs in a folder called candidates and the spreadsheet is in
this candidates folder and all the rest are separated from there based off
what business unit they have interest for (IE accounting, sales, marketing).

So would the address be what I list it as from here? For example Steve Smith
in the sales folder is: Sales/Smith from the location of the spreadsheet or
would it be C:\Candidates\Sales\Smith

and hyperlink needs to be in the language of my version of Excel?

OK I think this is starting to come together, thanks for the help.

"Dave Peterson" wrote:

The value in A3 has to be the address of the link--not the friendly name.

And you're going to have to translate the English =hyperlink() into the language
that you use.

KeepItCool has a translator utility at:
http://members.chello.nl/jvolk/keepitcool/

Longtime listener first time caller wrote:

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Thank you Dave I hope you navigate back to this post and if you don't I thank
you for the advice you have given me this far.

There are still a couple smaller things that are making this tough to
complete.

I tried out the testing in a new workbook and it worked, the hyperlink
showed up. But it only showed as a hyperlink after you clicked away from the
cell an essentially un-highlighted it. Is there anyway to change this or will
it be forever like this?

Thanks again, this solution does work!

"Dave Peterson" wrote:

Try creating a test formula (in your language) in an empty cell in a brand new
workbook:

=hyperlink("file:////C:\Candidates\Sales\Smith\cv.doc")
(I changed the name of the resume file to cv.doc)

Once you get this test formula working, you'll know what you have to use in the
real workbook.

Longtime listener first time caller wrote:

OK so I keep my CVs in a folder called candidates and the spreadsheet is in
this candidates folder and all the rest are separated from there based off
what business unit they have interest for (IE accounting, sales, marketing).

So would the address be what I list it as from here? For example Steve Smith
in the sales folder is: Sales/Smith from the location of the spreadsheet or
would it be C:\Candidates\Sales\Smith

and hyperlink needs to be in the language of my version of Excel?

OK I think this is starting to come together, thanks for the help.

"Dave Peterson" wrote:

The value in A3 has to be the address of the link--not the friendly name.

And you're going to have to translate the English =hyperlink() into the language
that you use.

KeepItCool has a translator utility at:
http://members.chello.nl/jvolk/keepitcool/

Longtime listener first time caller wrote:

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Maybe it's only a display problem.

If you close and reopen, does it look ok?

Maybe selecting the range and
edit|Replace
what: =
with: =
replace all

will force excel to notice that it's a hyperlink

(Just guesses)

Longtime listener first time caller wrote:

Thank you Dave I hope you navigate back to this post and if you don't I thank
you for the advice you have given me this far.

There are still a couple smaller things that are making this tough to
complete.

I tried out the testing in a new workbook and it worked, the hyperlink
showed up. But it only showed as a hyperlink after you clicked away from the
cell an essentially un-highlighted it. Is there anyway to change this or will
it be forever like this?

Thanks again, this solution does work!

"Dave Peterson" wrote:

Try creating a test formula (in your language) in an empty cell in a brand new
workbook:

=hyperlink("file:////C:\Candidates\Sales\Smith\cv.doc")
(I changed the name of the resume file to cv.doc)

Once you get this test formula working, you'll know what you have to use in the
real workbook.

Longtime listener first time caller wrote:

OK so I keep my CVs in a folder called candidates and the spreadsheet is in
this candidates folder and all the rest are separated from there based off
what business unit they have interest for (IE accounting, sales, marketing).

So would the address be what I list it as from here? For example Steve Smith
in the sales folder is: Sales/Smith from the location of the spreadsheet or
would it be C:\Candidates\Sales\Smith

and hyperlink needs to be in the language of my version of Excel?

OK I think this is starting to come together, thanks for the help.

"Dave Peterson" wrote:

The value in A3 has to be the address of the link--not the friendly name.

And you're going to have to translate the English =hyperlink() into the language
that you use.

KeepItCool has a translator utility at:
http://members.chello.nl/jvolk/keepitcool/

Longtime listener first time caller wrote:

When I put in the =hyperlink(a3) I get an error in the cell and it appears as
#NOM?

should I replace a3 with the cell I want to give the link location of or
just replace a3 with the link location, for instance Sales\Smith (this is
where the CV is located)

Yes the hyperlinks are listed in a column in the raw data

"Dave Peterson" wrote:

So one of the row or column or page fields is a hyperlink in the raw data?

If yes, then the "hyperlinkness" is lost when the pivottable is built.

If you're not pivotting too much, maybe you could add another column/row/cell
with a formula like:

=hyperlink(a3)
(if the cell's value shows the hyperlink address, that is)

Longtime listener first time caller wrote:

Hey all I'm working on a pivot table to keep track of CVs (resumes). In the
spreadsheet that holds the I hyper link to the actual CV but if I bring
something up in the pivot table it does not work.

Is there any solution to this or some way around it?

Thanks for your time.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson