View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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