email hyperlink won't change when cell content changes
 

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

email hyperlink won't change when cell content changes
 

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

AFAIK Only a macro can do this.

What you could do is paste the following into the 'ThisWorkbook' module:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
For Each xLink In Sh.Hyperlinks
xLink.Address = xLink.Parent.Text
Next xLink
End Sub

What this does is say, every time the worksheet recalculates, make the link address the same as the text in the cell. So, for any instances where the link address you see on the screen changes as the result of a formula, the actual link address is changed to suit.

Mark

email hyperlink won't change when cell content changes
 

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!

"Kevin B" wrote:

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