Don't use the insert|hyperlink version.

Try using an adjacent cell with the =hyperlink() worksheet function.

Al wrote:

Article ID : 214328 - Hyperlinks are removed or invalid after you sort cells
that contain these hyperlinks in Excel

Is there a way to resolve this issue?
Or does one have to continually fix the hyperlinks every time a worksheet is
updated? That is very time consuming when you have hundresd of links.

Microsoft simple says: Microsoft has confirmed that this is a problem in the
Microsoft products that are listed in the "Applies to" section.

No hint of a Hot Fix etc. to address the problem.

All suggestions are welcome
Al

--

Dave Peterson