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