is there a problem with hyperlink in excel 2003
I've been trying to work these suggestions into my formula but i'm not sure
if i am understanding what each argument means to enter it properly.
=HYPERLINK - i understand is the formula
("#"&CELL - does this represent something else other than what it
is... meaning
do i type this in as is or am i supposed to replace
it with an actual cell
reference?
("address",sheetone!C5), - i took this to mean the actual path to the
worksheet and
cell i'm trying to link to.. whe
("address", - means the workbook the sheets are located in
sheetone!C5), - means the sheet name and cell reference
perhaps this is where my mistake is?
sheetone!C5) - being the text in the linked to worksheet/cell being used
as a name
for the hyperlink
so this what i came up with.... but i get a #VALUE! error
=HYPERLINK("#"&CELL("New York",'YTD Income-Summary -
Cons'!A1),"Consolidated")
where "New York" is the workbook both sheets are in
where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
where !A1 is the cell i would like to link to
where "Consolidated" is the name i would like to name the link on the link
from
worksheet
can you tell what it is i'm doing wrong?
thanks.
"Dave Peterson" wrote:
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
Karenatallied wrote:
Hi Guys,
the scenario is as follows:
i am trying to link from a "Table of Contents" sheet to cell "A1" in a sheet
named "YTD Income Summary - ANY" and naming the link cell "New York Only".
Both the "Table of Contents" sheet and the "YTD Income Summary - ANY" sheet
are in the same workbook named "New York".
I used the HYPERLINK function shown below:
=HYPERLINK('YTD Income-Summary - ANY'!A1,"New York Only")
and also tried manually editing the formula as follows:
=HYPERLINK("[new york]'YTD Income-Summary - Cons'!A1","Consolidated")
where the sheet being linked to is "YTD Income-Summary - Cons", the link
cell is named "Consolidated" on the "Table of Contents" sheet and the
workbook containing both sheets is named "New York"
I get the same error message in both situations.
any insight would be appreciated...
Thanks :)
--
Dave Peterson
|