Hyperlink link_location error

[Cynthia Haggerty]

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

 

[Pete_UK]

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

 

[Cynthia Haggerty]

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

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

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

 

[Gary''s Student]

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

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

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

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

 

[Pete_UK]

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

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

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

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

 

[Gary''s Student]

Hi Pete:

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

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

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

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.

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
(e-mail address removed)> 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 -

 

[Cynthia Haggerty]

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

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

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

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
(e-mail address removed)> 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

 

[Pete_UK]

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

Hi Pete:

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

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

Nope, now the error is  "reference is not valid"
thanks though!  This is killing me cause i know it should work!
Cynthia
:
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
(e-mail address removed)> 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 -

 

[Cynthia Haggerty]

Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia

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

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

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.

On Aug 27, 3:15 pm, Cynthia Haggerty <Cynthia
(e-mail address removed)> 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 -

 

[Pete_UK]

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

Nope still get 'cannot open specified file'

I appreciate this!  thanks!

Cynthia

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

 

[Cynthia Haggerty]

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

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

Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia

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

 

[Gary''s Student]

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

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

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

Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



:
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

 

[Cynthia Haggerty]

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

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

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

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
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



:
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

 

[Gary''s Student]

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

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

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

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
:

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
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



:
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

 

[Pete_UK]

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

Thanks.

Pete

 

[Cynthia Haggerty]

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

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

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

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
:

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
Nope still get 'cannot open specified file'

I appreciate this! thanks!

Cynthia



:
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