XL: Hyperlinks Are Removed or Refer to Wrong Address After You Sort Them

ID: Q180700


The information in this article applies to:


SYMPTOMS

If you sort a range of cells in a worksheet that contains hyperlinks, the following problems may occur:


CAUSE

This problem may occur if you copy and paste cells that contain hyperlinks, and then sort the cells.


RESOLUTION

If this problem occurs, manually correct the hyperlinks. To do this, do either of the following:


STATUS

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

Additional query words: XL97 XL98 incorrect wrong


Keywords          : xlformula xlweb 
Version           : MACINTOSH:98; WINDOWS:97
Platform          : MACINTOSH WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 30, 1999