Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 03-13-2006, 02:10 PM   #1
Registered User
 
mkstein1's Avatar
 
Join Date: Mar 2002
Location: Ohio
Posts: 46
splat Excel help

I don't even know how to ask the questions. My problem is that I have a spreadsheet in Excel that has a column (amoungst others) for email addresses. If I right click on one of them that is underlined and blue, it suddenly causes an event to happen. It tries to spawn 62 emails! I am using Netscape and it is trying to use Internet Explorer to create and send these messages so I just X all 62. Some of the addresses are not blue and do not cause this event and naturally the empty (column - line intersections) boxes cause no action.

What is this action called? Is it something to do with "Hyperlink"? How can I turn it off?

Can you tell me what it is and where to look to read up on reconfiguring it, if I only knew what it is.
mkstein1 is offline   Reply With Quote
Old 03-13-2006, 03:21 PM   #2
glc
Forum Administrator
Staff
Premium Member
 
glc's Avatar
 
Join Date: May 2000
Location: Joplin MO
Posts: 37,776
Yes, you click on a hyperlink (an e-mail address *is* a hyperlink) and it will open your default e-mail program with a blank message addressed to that address.

You did not tell us what version of Excel you are using, but in Excel 2000, here's a Microsoft article that addresses this behavior:

http://support.microsoft.com/?kbid=233073
glc is offline   Reply With Quote
Old 03-13-2006, 06:53 PM   #3
Registered User
 
mkstein1's Avatar
 
Join Date: Mar 2002
Location: Ohio
Posts: 46
Thanks glc. I am on 97 SR-1 fwiw.
mkstein1 is offline   Reply With Quote
Old 03-14-2006, 09:24 AM   #4
glc
Forum Administrator
Staff
Premium Member
 
glc's Avatar
 
Join Date: May 2000
Location: Joplin MO
Posts: 37,776
Hmm - that's what I have - and dont have any settings involving hyperlinks.
glc is offline   Reply With Quote
Old 03-14-2006, 08:58 PM   #5
Registered User
 
mkstein1's Avatar
 
Join Date: Mar 2002
Location: Ohio
Posts: 46
Hey glc, I finally figured the only way I could break the hyperlink was to copy the entire worksheet, open a new sheet, paste special and use values.

After doing some more investigation, I suspect that the initial sheet was created in lotus, converted to excel and that is why I couldn't break the links. I did find some help, eventually, but it wouldn't work.
mkstein1 is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 01:53 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2