Hyperlink link_location error
 

Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia

Hyperlink link_location error
 

Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete


On Aug 27, 3:15*pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. *I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. *I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia

Hyperlink link_location error
 

Nope, now the error is "reference is not valid"
thanks though! This is killing me cause i know it should work!
Cynthia

"Pete_UK" wrote:

Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete


On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia

Hyperlink link_location error
 

1. drop the workbook / file name - not necessary
2. because the tab name has embedded spaces, it must be protected by single
quotes:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation Primers
working / ")

--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Nope, now the error is "reference is not valid"
thanks though! This is killing me cause i know it should work!
Cynthia

"Pete_UK" wrote:

Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete


On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia

Hyperlink link_location error
 

Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

On Aug 27, 3:43*pm, Cynthia Haggerty
wrote:
Nope, now the error is *"reference is not valid"
thanks though! *This is killing me cause i know it should work!
Cynthia



"Pete_UK" wrote:
Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. *I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. *I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia- Hide quoted text -

- Show quoted text -

Hyperlink link_location error
 

Hi Pete:

Is there any way to hyperlink to a Named cell using the hyperlink function??
--
Gary''s Student - gsnu2007xx


"Pete_UK" wrote:

Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

On Aug 27, 3:43 pm, Cynthia Haggerty
wrote:
Nope, now the error is "reference is not valid"
thanks though! This is killing me cause i know it should work!
Cynthia



"Pete_UK" wrote:
Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia- Hide quoted text -

- Show quoted text -

Hyperlink link_location error
 

OK< tried that no dice error is now 'reference is not valid'

What's that # in there for? I put it in as displayed...

without it I get the 'cannot open the sepcified file' error.

Oh and i am including the file name because eventually i'll be jumping to
another book.

Thanks!
Cynthia

"Gary''s Student" wrote:

1. drop the workbook / file name - not necessary
2. because the tab name has embedded spaces, it must be protected by single
quotes:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation Primers
working / ")

--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Nope, now the error is "reference is not valid"
thanks though! This is killing me cause i know it should work!
Cynthia

"Pete_UK" wrote:

Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete


On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia

Hyperlink link_location error
 

Use this:

=HYPERLINK("#My_name","jump")

My_name referred to cell H12 in the Sheet1, and the formula worked
from that sheet and from Sheet2. I've not tried it into another file.

Hope this helps.

Pete

On Aug 27, 4:08*pm, Gary''s Student
wrote:
Hi Pete:

Is there any way to hyperlink to a Named cell using the hyperlink function??
--
Gary''s Student - gsnu2007xx



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

On Aug 27, 3:43 pm, Cynthia Haggerty
wrote:
Nope, now the error is *"reference is not valid"
thanks though! *This is killing me cause i know it should work!
Cynthia

"Pete_UK" wrote:
Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. *I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. *I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Hyperlink link_location error
 

Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia

"Pete_UK" wrote:

Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

On Aug 27, 3:43 pm, Cynthia Haggerty
wrote:
Nope, now the error is "reference is not valid"
thanks though! This is killing me cause i know it should work!
Cynthia



"Pete_UK" wrote:
Try it like this:

=HYPERLINK("[Revco -80 freezer.xls]CHiP Validation Primers!A1","Gaby
ChIP Validation Primers working / ")

i.e. you must include the .xls extension with the filename.

Hope this helps.

Pete

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
wrote:
Hello, trying to jump to a different page in the same workbook. I keep
getting the error 'cannot open the specified file', though i am working in
the requested file. I suspect i have an error in the link_location somehow.

Current hyperlink:
=HYPERLINK("[Revco -80 freezer] CHiP Validation Primers!A1","Gaby ChIP
Validation Primers working / ")

where 'Revco -80 freezer' is the file I'm working in
where 'CHip Validation Primers' is the page I want to go to and
where 'Gaby ChIP Validation Primers working / ' is the freindly_name
displayed and
where A1 is the cell to go to.

What am I doing wrong?
thanks,Cynthia- Hide quoted text -

- Show quoted text -

Hyperlink link_location error
 

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56*pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! *thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

Hyperlink link_location error
 

Very sure. I copied it from the directory, beacuse that was one of the first
things i thought of. I did try it with the # =HYPERLINK("#'CHiP Validation
Primers'!A1","Gaby ChIP Validation Primers working / ") and got reference
not valid. also tried without the cell number =HYPERLINK("#'CHiP Validation
Primers'","Gaby ChIP Validation Primers working / ") and got 'reference is
not valid'

Cynthia
"Pete_UK" wrote:

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56 pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

Hyperlink link_location error
 

I put a workbook in C:\Temp
and this worked for me:

=HYPERLINK("[C:\Temp\Revco -80 freezer.xls]'CHiP Validation Primers'!A1")

Naturally you will adjust for your own folder name and include any
"friendly" name in the function call.

I had to:

1. include the full path/filename between the brackets
2. include the tab name between the single quotes
--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Very sure. I copied it from the directory, beacuse that was one of the first
things i thought of. I did try it with the # =HYPERLINK("#'CHiP Validation
Primers'!A1","Gaby ChIP Validation Primers working / ") and got reference
not valid. also tried without the cell number =HYPERLINK("#'CHiP Validation
Primers'","Gaby ChIP Validation Primers working / ") and got 'reference is
not valid'

Cynthia
"Pete_UK" wrote:

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56 pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

Hyperlink link_location error
 

Hooray! It works! total path name! with single quotes around the tab!

=HYPERLINK("[pathname\file name.ext]'tab name'!CR","friendly name")

Thanks all for the discussion! I was able to repeat the sucess. So I feel
confident that that's the correct answer.

THANK YOU! THANK YOU! THANK YOU!

Cynthia

"Gary''s Student" wrote:

I put a workbook in C:\Temp
and this worked for me:

=HYPERLINK("[C:\Temp\Revco -80 freezer.xls]'CHiP Validation Primers'!A1")

Naturally you will adjust for your own folder name and include any
"friendly" name in the function call.

I had to:

1. include the full path/filename between the brackets
2. include the tab name between the single quotes
--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Very sure. I copied it from the directory, beacuse that was one of the first
things i thought of. I did try it with the # =HYPERLINK("#'CHiP Validation
Primers'!A1","Gaby ChIP Validation Primers working / ") and got reference
not valid. also tried without the cell number =HYPERLINK("#'CHiP Validation
Primers'","Gaby ChIP Validation Primers working / ") and got 'reference is
not valid'

Cynthia
"Pete_UK" wrote:

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56 pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

Hyperlink link_location error
 

You are very welcome. This will be as valuable to me as to you.
--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Hooray! It works! total path name! with single quotes around the tab!

=HYPERLINK("[pathname\file name.ext]'tab name'!CR","friendly name")

Thanks all for the discussion! I was able to repeat the sucess. So I feel
confident that that's the correct answer.

THANK YOU! THANK YOU! THANK YOU!

Cynthia

"Gary''s Student" wrote:

I put a workbook in C:\Temp
and this worked for me:

=HYPERLINK("[C:\Temp\Revco -80 freezer.xls]'CHiP Validation Primers'!A1")

Naturally you will adjust for your own folder name and include any
"friendly" name in the function call.

I had to:

1. include the full path/filename between the brackets
2. include the tab name between the single quotes
--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Very sure. I copied it from the directory, beacuse that was one of the first
things i thought of. I did try it with the # =HYPERLINK("#'CHiP Validation
Primers'!A1","Gaby ChIP Validation Primers working / ") and got reference
not valid. also tried without the cell number =HYPERLINK("#'CHiP Validation
Primers'","Gaby ChIP Validation Primers working / ") and got 'reference is
not valid'

Cynthia
"Pete_UK" wrote:

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56 pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete

Hyperlink link_location error
 

Me as well - I don't use hyperlinks very often, but I've learnt
something today with this.

Thanks.

Pete

On Aug 27, 7:28*pm, Gary''s Student
wrote:
You are very welcome. *This will be as valuable to me as to you.
--
Gary''s Student - gsnu200801

Hyperlink link_location error
 

Just discovered another thing if the tabname has an apostrophe, get rid of
it! it gives the 'reference not valid' error. Argh! Then it works...

Cynthia

"Cynthia Haggerty" wrote:

Hooray! It works! total path name! with single quotes around the tab!

=HYPERLINK("[pathname\file name.ext]'tab name'!CR","friendly name")

Thanks all for the discussion! I was able to repeat the sucess. So I feel
confident that that's the correct answer.

THANK YOU! THANK YOU! THANK YOU!

Cynthia

"Gary''s Student" wrote:

I put a workbook in C:\Temp
and this worked for me:

=HYPERLINK("[C:\Temp\Revco -80 freezer.xls]'CHiP Validation Primers'!A1")

Naturally you will adjust for your own folder name and include any
"friendly" name in the function call.

I had to:

1. include the full path/filename between the brackets
2. include the tab name between the single quotes
--
Gary''s Student - gsnu200801


"Cynthia Haggerty" wrote:

Very sure. I copied it from the directory, beacuse that was one of the first
things i thought of. I did try it with the # =HYPERLINK("#'CHiP Validation
Primers'!A1","Gaby ChIP Validation Primers working / ") and got reference
not valid. also tried without the cell number =HYPERLINK("#'CHiP Validation
Primers'","Gaby ChIP Validation Primers working / ") and got 'reference is
not valid'

Cynthia
"Pete_UK" wrote:

Are you sure you have spelt the filename exactly correct? Make sure
you have the right number of spaces (for example, should there be a
space after the hyphen? Are there any double-spaces in the filename?)

Pete

On Aug 27, 4:56 pm, Cynthia Haggerty
wrote:
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



"Pete_UK" wrote:
Okay, I omitted the 2 apostrophes around the reference - try this:

=HYPERLINK("'[Revco -80 freezer.xls]CHiP Validation Primers'!A1","Gaby
ChIP Validation Primers working / ")

or this is a bit shorter:

=HYPERLINK("#'CHiP Validation Primers'!A1","Gaby ChIP Validation
Primers working / ")

The # basically means "in this file".

Hope this helps.

Pete