[mso] Re: Hyperlink in Excel

Your attachment has been stripped.

Is this the only place it's happening, or is it consistent in all workbooks?

If you can reproduce it, please describe the exact steps - starting with an 
empty sheet.

I am also using 2003, and my tests didn't reproduce it.

What do you mean by "when I go into that cell"?  There are lots of ways of 
going into a cell.  If you mean left click, then that is certainly the 
expected action for a hyperlink; if you mean with the keyboard, then it 
shouldn't go there; if you mean with click and hold, then it shouldn't go 
there.

Do you have any third-party add-ins running?  Is there any VBA code (macros) 
in the workbook?

Regards, Dave S

----- Original Message ----- 
From: "Peggy Knesebeck" <pknesebeck@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Tuesday, August 07, 2007 1:45 AM
Subject: [mso] Re: Hyperlink in Excel


>
> I've tried your suggestions, but still no luck.  I've attached a sample 
> file
> so you can see what is happening with the resulting hyperlink.  I am using
> Excel v 2003.  Excel still calculates the formula correctly, however it is
> frustrating because when I go into that cell, it automatically takes me 
> into
> email trying to send it!  I tried to right click to remove the hyperlink,
> butdid not get that option.
>
> Thanks for trying to help with this problem.
>
> Peggy
>
> ----------------------------------------------------------------------------
> From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
> Reply-To: mso@xxxxxxxxxxxxx
> To: <mso@xxxxxxxxxxxxx>
> Subject: [mso] Re: Hyperlink in Excel
> Date: Sat, 4 Aug 2007 18:52:09 +1000
>>I've just been playing with this in Excel 2003 and I can't get it to
>>auto-format the result of a FORMULA as a hyperlink at all.
>>
>>Do you have a specific example?
>>
>>It will, of course, auto format a URL or e-mail address typed directly 
>>into
>>a cell. (Not "every once in a while" - it's quite consistent.) There are
>>two parts to this:
>>
>>- The look. This is a style and can simply be removed by selecting a
>>different style.
>>
>>- The feel. Simply right click on the cell and select "remove hyperlink".
>>
>>(The right click option removes the look as well.)
>>
>>But, if you type a non-URL or e-mail address into a cell that previously
>>held one, Excel won't remove the hyperlink information.
>>
>>Next question is why this is giving you trouble. Is it that you can't 
>>click
>>the cell to select it? If so, hover over the cell and the pop-up will
>>remind you that click-and-hold will select it. (You know it's a hyperlink
>>because of the look of the cell or the look of the cursor when it's over
> the
>>cell.)
>>
>>Regards, Dave S
>>
>>----- Original Message -----
>>From: "Peggy Knesebeck" <pknesebeck@xxxxxxxxxxx>
>>To: <mso@xxxxxxxxxxxxx>
>>Sent: Saturday, August 04, 2007 1:57 AM
>>Subject: [mso] Hyperlink in Excel
>>
>>
>>>
>>>Does anyone know why Excel some times automatically formats the results 
>>>of
>>>a
>>>formula into a hperlink? Even when I format the cell afterward, it still
>>>remains a hyperlink! This does not happen all the time, but every once in
>>>a
>>>while and I cannot figure out why. Even when the cell is formatted this
>>>way,it still calculates the formula correctly.
>>>
>>>Thanks in advance for your help.
>>>
>>>
>>>
>>>Peggy
>>>
>>>
>>>
>>>
>>>--------------------------------------------------------------------------
> --
>>>A new home for Mom, no cleanup required. All starts here.[1]
>>>
>>>--- Links ---
>>>1 http://g.msn.com/8HMAENUS/2737??PS=47575
>>>*************************************************************
>>>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
>>>or
>>>MicrosoftOffice@xxxxxxxxxxxxxxxx
>>>
>>>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>>
>>>To Unsubscribe from this group, visit the group's homepage and use the
>>>dropdown menu at the top. This will allow you to unsubscribe your email
>>>address or change your email settings to digest or vacation (no mail).
>>>http://www.freelists.org/webpage/mso
>>>
>>>To be able to share files with the group, you must join our Yahoo sister
>>>group. This group will not allow for posting of emails, but will allow
>>>you to join and share problem files, templates, etc.:
>>>http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
>>>FILE SHARING ONLY.
>>>
>>>If you are using Outlook and you see a lot of unnecessary code in your
>>>email messages, read these instructions that explain why and how to fix
>>>it:
>>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>*************************************************************
>>>
>>
>>*************************************************************
>>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>>
>>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>>
>>To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
>>http://www.freelists.org/webpage/mso
>>
>>To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow you
> tojoin and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE
> SHARING ONLY.
>>
>>If you are using Outlook and you see a lot of unnecessary code in your
> emailmessages, read these instructions that explain why and how to fix it:
>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>*************************************************************
>
>
> ----------------------------------------------------------------------------
> More photos, more messages, more storage-get 2GB with Windows Live
> Hotmail.[1]
>
> --- Links ---
>   1 http://g.msn.com/8HMBENUS/2746??PS=47575
>
> -- No attachments (even text) are allowed --
> -- Type: application/vnd.ms-excel
> -- File: 07July Sample.XLS
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
> 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: