Excel Question #46 - Page 3

Kevy Baby · 08-08-2008, 02:18 PM

Is there a way to tell Excel to stop turning email addresses in Excel databases into hyperlinks? We keep (small) databases in Excel and when we enter an email address, it automatically turns it into a hyperlink.

Previously, I just ignored this, but ran into an issue today where someone who I gave the database to so that they could email things for me was just clicking on the hyperlinked email address to address the email. The problem is that on a few records, when an email address was changed (usually because of personnel change for that record), the hyperlink did not automatically update.

I was able to do a mass change to ensure that the problem does not occur for the list as it exists right now, but I am searching for a long term solution.

08-08-2008, 02:18 PM	#1
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Excel Question #46 Is there a way to tell Excel to stop turning email addresses in Excel databases into hyperlinks? We keep (small) databases in Excel and when we enter an email address, it automatically turns it into a hyperlink. Previously, I just ignored this, but ran into an issue today where someone who I gave the database to so that they could email things for me was just clicking on the hyperlinked email address to address the email. The problem is that on a few records, when an email address was changed (usually because of personnel change for that record), the hyperlink did not automatically update. I was able to do a mass change to ensure that the problem does not occur for the list as it exists right now, but I am searching for a long term solution. __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes