Hyperlinks not moving with cells when data is sorted
 

I have a spreadsheet where I have included hyperlinks. When I sort the data
or add new rows, the hyperlinks are NOT moving to the new destination of the
cell. Big problem! How do I get Excel to keep the hyperlink moving with the
cell, wherever it may go?

Using Excel 2003.

Thanks.
--
Marina