I am updating a spreadsheet that includes e-mail addresses in one column.
Every time I type an address, Outlook opens as if I were attempting to send a
message. I don't want that to happen. I just want to update my list. How
to I keep Outlook from opening every time I go near an e-mail address in my
spreadsheet?
Thanks.

From Microsoft's help file
-----------------------------

Deactivate several hyperlinks at once

Type the number 1 in a blank cell, and right-click the cell.

Click Copy on the shortcut menu.

While pressing CTRL, select each hyperlink (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a location in a
file, a Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.)
you want to deactivate.

-- To select a cell that has a hyperlink (hyperlink: Colored and underlined
text or a graphic that you click to go to a file, a location in a file, a Web
page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also
go to newsgroups and to Gopher, Telnet, and FTP sites.) in it without jumping
to the hyperlink destination, click the cell and hold the mouse button until
the cursor becomes a (white) cross, then release the mouse button.

Click Paste Special on the Edit menu.

Under Operation, click Multiply and then click OK.

"D.Warner" wrote:

I am updating a spreadsheet that includes e-mail addresses in one column.
Every time I type an address, Outlook opens as if I were attempting to send a
message. I don't want that to happen. I just want to update my list. How
to I keep Outlook from opening every time I go near an e-mail address in my
spreadsheet?
Thanks.

You can eliminate hyperlinks as in your other reply but since you did not
indicate that was what you wanted, suggest you use the arrow key to
get into the cell, or click on the cell and slowly release, or right click
on the cell when selecting. Additional suggestions in
http://www.mvps.org/dmcritchie/excel...c.htm#avoiding
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"D.Warner" wrote ...
I am updating a spreadsheet that includes e-mail addresses in one column.
Every time I type an address, Outlook opens as if I were attempting to send a
message. I don't want that to happen. I just want to update my list. How
to I keep Outlook from opening every time I go near an e-mail address in my
spreadsheet?
Thanks.