Hyperlink function - double-click opens cell for edit

[Ameliacat]

This is a basic question on the Hyperlink function.

In a new workbook, with blank Sheet1, Sheet2, Sheet3, I've
entered the following in Sheet1!B6:
=HYPERLINK(Sheet2!A14,"Test Link")

The cell now displays "Test Link" in underlined blue font.

When I double-click on the cell, it opens for edit, rather
than jumping to Sheet2!A14.

What am I missing?

 

[Paulw2k]

Hi,

It has probably to do with the way you created it. I have had this problem
before.
To create it (again) go to INSERT/HYPERLINK and do the necessary in the
resulting dialogue box.
The resulting link will then work.

Regards

Paul

 

[DDM]

Ameliacat, the problem lies with the syntax of your HYPERLINK formula. Try
it this way:

=HYPERLINK("[Book1]Sheet2!A14","Test Link").

Adjust the file and worksheet names as necessary.