Article ID: 177841
Article Last Modified on 10/19/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q177841
SYMPTOMS
If you sort cells that contain hyperlinks, the hyperlinks may not be sorted
correctly or the hyperlinks may no longer function.
CAUSE
This behavior occurs when the following conditions are true:
- You copy a hyperlink in a cell and paste it to a range of cells or
you use the Fill command (on the Edit menu) to fill a range of cells
with a hyperlink.
NOTE: The range in which you are pasting must be more than one cell.
-and-
- You sort the range of cells with the pasted or filled links so that
the cells are sorted by using values in another column.
NOTE: This problem does not occur when you use the HYPERLINK worksheet
function.
RESOLUTION
To resolve this problem, use the HYPERLINK function to create the hyperlink
in the cell. After you do this, you can copy the cell that contains the
HYPERLINK function and paste it in range of cells. The hyperlink functions
correctly after you sort it.
You can also work around this problem by copying the hyperlink and pasting
it one cell at a time.
STATUS
Microsoft has confirmed this to be a problem in the products listed at the
beginning of this article.
REFERENCES
For more information about creating hyperlinks, click the Office Assistant,
type
How do I create a hyperlink click Search, and then click to view
"Create a hyperlink."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
120802
Office: How to Add/Remove a Single Office
Program or Component
Additional query words: XL97
Keywords: kbbug kbweb KB177841