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 :)