Hyperlink Not Restored When You Click Undo Hyperlink
Article ID: 177110
Article Last Modified on 8/19/2003
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q177110
SYMPTOMS
If you click Undo Hyperlink on the Edit menu after removing a hyperlink
from a cell in a worksheet, the removed hyperlink is not correctly
restored. Although the cell appears to contain a hyperlink, the hyperlink
does not work when you click it.
CAUSE
This problem occurs if you perform the following steps:
- In Microsoft Excel, select a cell that contains a hyperlink.
NOTE: You cannot select the cell by clicking it; you must use the
keyboard or the Go To dialog box (on the Edit menu, click Go To) to
select the cell.
- On the Insert menu, click Hyperlink.
- Click Remove Link.
The hyperlink is removed from the cell.
- On the Edit menu, click Undo Hyperlink.
The cell now appears to contain a hyperlink. However, if you click the
cell, the hyperlink does not work.
RESOLUTION
If this problem occurs, you must manually recreate the hyperlink by
selecting the cell and clicking Hyperlink on the Insert menu. Type the
file name or URL in the edit box, or select the appropriate file name or
URL in the list box. Then, click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.
Additional query words: XL97 XL
Keywords: kbbug KB177110