XL97: Range of Pasted Hyperlinks May Not Be Sorted Correctly

• Microsoft Excel 97 for Windows

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.

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:

Q120802 Office: How to Add/Remove a Single Office Program or Component

Additional query words: XL97

Keywords : kbweb xllist
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug