Hyperlink() problems

[John Smith]

The =hyperlink() function is not working for me. I have Office 200
English version. In Excel I tried:

=Hyperlink(“HD!A1”,HD!A1)

The reference text on sheet HD cell A1 is shown as the hyperlink ok
But when trying jumping with the link to Sheet HD I am getting th
error message:

Cannot open the specified file

The hyperlinks made by object hyperlink is working ok. Also I trie
making a hyperlink like:

=hyperlink(“http://www.microsoft.com”,”test”) this is also jumping fin
to the MS homepage.

It seems I have some problems jumping inside the same document. Ca
there bee some setting in Excel that is preventing me form jumpin
inside the same file.
Please help

 

[Frank Kabel]

Hi
try:
=Hyperlink(“#HD!A1”,HD!A1)

 

[John Smith]

Thank

 

[Guest]

Is it possible to copy this formula to other cells using Autofill and has the
cell references be relative?

 

[David McRitchie]

Hi Mary,
Yes, you have to get the part that changes out of the quotes.
=HYPERLINK("#"&CELL("address",HD!A1),HD!A1)
if you had spaces in the worksheetname, which you can see the formula
change if you renamed the worksheet, something you would not see happen
if everything were within double quotes.
=HYPERLINK("#"&CELL("address",'HD One'!A1),'HD One'!A1)

More information in:
http://www.mvps.org/dmcritchie/excel/sheets.htm