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 above. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component