Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink error | Excel Discussion (Misc queries) | |||
hyperlink error | Excel Worksheet Functions | |||
how to import the link_location from an other hyperlink cell | Excel Worksheet Functions | |||
HYPERLINK link_location could not exceed 255 chars | Excel Discussion (Misc queries) | |||
Display link_location instead of friendly name | Excel Worksheet Functions |