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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to named range in workbook 1
Using Hyperlink Function 5
how do I drag and fill hyperlinks? 3
Show in a Cell the Value for another Cell 2
Creating a hyperlink to a cell on a different sheet 1
HYPERLINK() Help 1
use of ADDRESS function within CELL function 4
Hyperlink based on cell value in a different worksheet 4

Back
Top