E-Mail Issue in Excel

[Guest]

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

 

[JP]

If you are comfortable with VBA, just highlight your data and type
"Selection.hyperlinks.delete" in the immediate window.

1. Hit Alt-F11 to bring up the VB Editor
2. Ctrl-G to bring up the Immediate Window
3. type "selection.hyperlinks.delete" and hit enter

The hyperlinks should be gone.


HTH,
JP

 

[Guest]

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

Try this:
1) right click on the cell with the email
2) select "remove hyperlink"
3) click on the "format painter icon"
4) select the colums with the email addresses. This should remove the
hyperlinks.

 

[Guest]

Thanks for the quick solution. This worked great!

 

[JP]

Glad we could help!

--JP

Thanks for the quick solution. This worked great!

 

[mj]

I had the same problem, and JP's solution was perfect! Thank you!