paddyabdul

In Excel 2007, if you add a hyperlink to some text in a cell then all is well and good until you sort a bunch of data, whereupon the hyperlink does not move with the data (text in this case) but stays associated with the cells relative position ! e.g. cell E3 has a hyperlink associated with it, if you then sort by some criteria the data in that cell may move to say E15 but the hyperlink stays on cell E3 and doesnt move with the text. Anyone know how to solve this ? Thanks.