XL97: Double-Clicking Hyperlink May Activate Edit Mode

ID: Q154901

The information in this article applies to:

SYMPTOMS

When you double-click a hyperlink in Microsoft Excel, you may end up in Edit mode in the destination cell for the hyperlink.

RESOLUTION

If you double-click a hyperlink in Microsoft Excel, and the link points to a cell within any sheet in the active workbook, you may end up in Edit mode in the destination cell. To prevent this from occurring, single-click the hyperlink, as the hyperlink will take you directly to the destination cell. There is no need to double-click the hyperlink.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

You can create hyperlinks to other files on your computer, your network, the Internet, or to other cells or defined names within the current workbook. A hyperlink to another location within the current workbook looks very similar to a linking formula, except that the hyperlink is not preceded by an equal sign (=).

To create a hyperlink from cell A1 in Sheet1 to cell A1 in Sheet2 in the same workbook, follow these steps:

1. Select cell A1 in Sheet1.

2. Click the Insert Hyperlink toolbar button.

3. In the Insert Hyperlink dialog box, click Browse to the right of the

   "Named location in file: (Optional)" box.

4. In the "Browse Excel Workbook" dialog box, click Sheet Name
   and type "A1" (without the quotation marks) in the Reference box. Then,
   click Sheet2 in the list of sheets in the workbook, and click OK.

5. Click OK.

   In cell A1, you will have a hyperlink that when clicked once, will
   activate cell A1 in Sheet2.

REFERENCES

For more information about Hyperlinks, click the Index tab in Microsoft Excel Help, type the following text

   hyperlinks

and then double-click the selected text to go to the "create a hyperlink (Microsoft Excel)" topic.

Additional query words: intranet www world wide web

Keywords          : kbualink97
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 3, 1998