For whatever reason every cell in my workbook has a hyperlink on it to an email address. Is there any way to remove all the hyperlinks at once in one sheet? Right now I am removing one at a time. Also, any idea how this could have happened?
I have run into the same situation. It is quite annoying. Anytime you enter an email address in Excel, or edit an email address in Excel, it automatically converts it to a hyperlink. I don't think there is any way to disable that behavior.
Thanks! Is this a VBA code? I'm really only experienced in formula's and some formatting as our spreadsheets are used for accounting purposes. How do I use this code? We do have email addresses that are in there but it's okay that they're hyperlinks. The problem is the entire workbook every cell has turned into a hyperlink when it's basic text not an email address. Very strange.