Hi Nona,
The easy way to disassociate is to edit the hyperlink, i.e. right click the
cell or go to INSERT menu, HYPERLINK, edit/change as per your need.
Try this and your prob will be solved.
Regards,
PDS.

"Nona" wrote:

i maintain a database in excel which includes mailto: addresses. when a
change to the mailto address is necessary, it displays the proper address but
when clicked to send an email, it remembers the old mailto address that was
first input in the cell. How can i get excel to disassociate from an address
once it's changed?