[mso] Re: Hyperlink in Excel

Peggy,

By the sound of it your worksheet is protected and you will therefore not be
able to delete the hyperlink via the right click option. Once un-protected
the Edit Hyperlink option will be available on right click.

Hope that fixes it!!

-- 
Geoff Culbertson
Petersfield, Hampshire, U.K.

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Peggy Knesebeck
Sent: 06 August 2007 16:45
To: mso@xxxxxxxxxxxxx
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: