is there a problem with hyperlink in excel 2003
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
|