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