Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink in a cell

    Sometimes when I enter data in EXCEL 2010 on a Windows 7 system in a general cell, the cell contents become a hyperlink when I get out of the cell. I do NOT want this. Any ideas what I am doing to cause this to occur? I can't seem to determine what I am doing wrong.
    THANX

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Are you entering an email address?

    You can stop this autocorrect in Options, Proofing, AutoCorrect and uncheck the first box.

  3. #3
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    NO, just entering text and it turns the contents of the cell into a hyperlink

  4. #4
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ALSO, I am using EXCEL 2007, not 2010 (different computer). I have used EXCEL for many years but this behaviour is new to me. I'm not sure if it is some content or I hit a key on my keyboard that causes this. I can't repeat it -- it just happens several time a month. THANX!

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Could you post a sample?

  6. #6
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry, when the problem occurs I UNDO my change and very carefully REDO the changes. I don't keep the bad cell. I will post an example when it occurs next.

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Are you by chance using a programmable macro keyboard? I have a dedicated key to hyperlink text on mine.

  8. #8
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't think so. I am using an HP all-in-one computer with a USB keyboard at work & an HP Pavilion Laptop at home with same problem on both on the same Excel file.

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    In the cell(s) that turn into hyperlinks, do you have double slashes, by any chance? eg: \\ or \\text ?

    Those turn into hyperlinks. So will web addresses or ftp:// or mailto: or file://

  10. #10
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No but usually I have part of the text in bold blue. That seems to be a trigger but not always.

  11. #11
    New Lounger Ensemble's Avatar
    Join Date
    Apr 2013
    Location
    Centurion
    Posts
    23
    Thanks
    9
    Thanked 1 Time in 1 Post
    Where/what does it link to? what happens if you follow the link?

    Does it occur in random cells or only in a certain range?

  12. #12
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The link is bad since it is based on the text in the cell.

    The spreadsheet is a log of customer contacts, activity discussed & follow up.

    This behaviour occurs only in the text cell describing the contact and is usually when I copy a line pf a past contact and add it as the basis for a new contact with the same customer. The contact info cell in the new line is what goes wrong when I make the updates and exit. The cell is defined as General and I have tried clearing all formatting on this cell.

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you elaborate on when it seems to occur?
    For example, does it happen in any workbook? Or only particular workbooks and/or particular worksheets?
    Is it particular text that creates the link?
    Is it actually a link or only text formatted to look like a link? (when you hover over the cell, does it change to a finger-pointing icon?)

    Steve

  14. #14
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Sounds as though you are pasting some formatting inherited from the copy process from the source cell.

    Check the cell(s) that you are copying from to see if any formatting exists.

  15. #15
    New Lounger
    Join Date
    Jan 2014
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It happens only in one workbook with one worksheet on one column defined as a GENERAL cell.

    ALL the text in that cell sometimes (why I am not sure) changes to a blue underlined hyperlink.

    If I click the cell to fix it, it tries to create a mail message, obviously thinking that the contents are an e-mail address, so YES the mouse pointer changes to a finger.

    I just noticed that when I put an e-mail address or web address in the cell, there is a small bar at the top left of the cell directly below it. When I hover over it, it says that it is AUTOCORRECT OPTIONS and when I select it, there are 3 options:

    Undo Hyperlink
    Stop Automatically Creating Hyperlinks
    Control Autocorrect Options

    Item #2 sounds like it would accomplish what I want.
    Item #3 under the Autoformat As You Type TAB allows me to control Hyperlinks (similar to what kweaver mentioned in MSG #2)

    At this point, I am going to assume I have inadvertantly entered an e-mail address (generally invalid) in my cell and because I have Hyperlinks enabled, that is what is causing my problems.

    I have other cells in this worksheet that COULD contain an e-mail address. How can I set up my Workbook/Worksheet controls that would BLOCK e-mail addresses in one cell but ALLOW it in another cell in the same row?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •