Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: How do I find and break links?

  1. #1
    Guest

    Default

    I have a large spreadsheet. When I go to Edit/Links, it says I have links to two other spreadsheets on my C drive. I've done a Find for the filenames and they don't turn up in any of the tabs. Nothing ending in XLS.

    Is there a way to find which formulas contain the links? Could something besides formulas be linked? I want to get rid of the links.

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check to see if you have any Named Ranges linked to other Workbooks

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Common question.. can i suggest search links and these bundels there. Check out my pal Chris Davidson, he love links and has a way arrond this, find him in memebers.. about assigning links to dummy link delete... very cleaver.



    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A quick way to look at your formulae is by hitting your ctrl key and ~ at the same time. Links also tend to build up in the name ranges. Go to insert->names->define... and if you have names, just highlight them and see what they're referring to.

    Also, these guys say they have a program to delete the links, haven't tried it, but here's the link:

    http://www.erlandsendata.no/english/.../findlinks.htm

    Hope this helps.

    Cheers, NateO

    [ This Message was edited by: NateO on 2002-03-14 15:39 ]

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    NateO

    I was trying to get rid of some similarly ghostly links, so I followed your "Ctrl+~" advice in one of the sheets of my workbook. It didn't appear to do anything at all, but somehow the links problem has stopped popping up! How did this fix my problem??

    Thanks BTW!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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