email hyperlink won't change when cell content changes

[Emmac]

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????

 

[Kevin B]

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.

 

[Emmac]

Thanks but I'm still not able to make changes - if I right click the cell I
have the option to open the hyperlink but the options Edit Hyperlink and
remove hyperlink are not bold and I can not click on them. If I click open
hyperlink then outlook opens with the original email displayed in the "TO"
box??!!?? Any other help or ideas would be appreciated!