+ Reply to Thread
Results 1 to 4 of 4

Excel doesn`t check if the links inside cells are online when clicking

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    2

    Angry Excel doesn`t check if the links inside cells are online when clicking

    Hello guys,

    I`m encountering a problem. I`ve reinstalled Windows on my work computer.
    My job is as an network engineer. I have to fix connections all day. I`ve made a table witch stores in first column the name of the connection, the second column containing the IP addres of that connection (with an "http://" add so it can be clickable).
    Before resinstall I used Excel to verify if the connection is up, because if I clicked a link that`s offline, Excel would freeze until I would press Escape or the link would get online.
    It had helped me a lot.
    Now, I click an IP (EG http://1.1.1.1 ) and nothing happens in Excel, I can still use it and edit stuff in Excel, it would just return a message in seconds/minutes "Unable to reach [..]"
    Do you happen to know what can I do to fix this?

    Please help me !


    Mihai

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: Excel doesn`t check if the links inside cells are online when clicking

    Hi nookie,

    Welcome to the forum.. Had chance to check this?

    http://support.microsoft.com/kb/2597992

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel doesn`t check if the links inside cells are online when clicking

    how are you constructing the hyperlink?
    have you tried
    =HYPERLINK("http://"&A1) where a1 is the ip address
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    04-10-2014
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel doesn`t check if the links inside cells are online when clicking

    Hello again and thank you for your interest,

    I`ve tried both of your solutions:

    1) Adding a ForceShellExecution in
    32-bit: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet
    64-bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internet

    Well I don`t have that key in my registry.
    Done that in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Common\Internet
    asdasdasd.jpg
    But nothing new happened.

    2) I`ve constructed the hyperlink, it`s clickable, but it still doesn`t wait for a response.

    Nothing worked so far


    Good day !
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel links to file that doesn't exist
    By Chezterfield in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2011, 07:08 AM
  2. Check for links to other cells?
    By GoldenArm in forum Excel General
    Replies: 2
    Last Post: 01-24-2011, 12:28 PM
  3. clicking on formula doesn't highlight cells in formula
    By john4430 in forum Excel General
    Replies: 5
    Last Post: 01-04-2011, 02:52 PM
  4. macro automatically clicking links in cells
    By akxander in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-30-2009, 02:13 PM
  5. Replies: 4
    Last Post: 01-05-2006, 10:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1