The text you're seeing in the cell is the display text for the hyperlink and
not the hyperlink itself, so when you modify the cell contents the hyperlink
to the original email address does not change.

Right click on the hyper-link cell that you want to update and select EDIT
HYPERLINK from the short cut menu. Make your change to the hyperlink by
editing the ADDRESS field at the bottom of the dialog box, and the text to
display in the worksheet to TEXT TO DISPLAY field at the top of the dialog
box.

Hope this helps.
--
Kevin Backmann


"Emmac" wrote:

I have a column containing email addresses in my spread sheet. I am trying
to update the data - I can change the information in the cell but when I
hover over it I am shown the old email address as the hyperlink. If I click
on the new email address typed into the cell an outlook page opens with the
old deleted address in the To box. How can I change the hyperlink to match
the new cell contents????