Hyperlink function - double-click opens cell for edit

  • Thread starter Thread starter Ameliacat
  • Start date Start date
A

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?
 
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
 
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.
 
Back
Top