Results 1 to 6 of 6

Thread: Unable to break external link
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular masud8956's Avatar
    Join Date
    Oct 2016
    Location
    Dhaka, Bangladesh
    Posts
    147
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Unable to break external link

    Hi,

    I have two workbooks. Both have one sheet with identical structure. So, for workbook 2, I just copied the sheet from workbook 1. There after I made amendments to workbook 2 formulas. These two workbooks are not required to be linked in any way. But every time I open workbook 2, I get a dialogue box asking me if I want to update the link.

    I tried to get rid of this from Data Tab by 'Break Links' option but it does not work. Here to be mentioned that I also have some shapes in my worksheet.

    How can I get rid of the external links?

    TIA

  2. #2
    Board Regular
    Join Date
    Sep 2012
    Posts
    132
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable to break external link

    Do these shapes perhaps contain links to outside sources?

    Graphs are also a good place for external links to hide.

  3. #3
    Board Regular masud8956's Avatar
    Join Date
    Oct 2016
    Location
    Dhaka, Bangladesh
    Posts
    147
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable to break external link

    No, I checked. Those shapes are not linked. I do not have any graphs as well.

  4. #4
    Board Regular
    Join Date
    Sep 2012
    Posts
    132
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable to break external link

    Last thing i can think of are named ranges with external links in it.

  5. #5
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,276
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Unable to break external link

    See if this reference on finding external links helps.
    https://support.office.com/en-us/art...5-54313a532ff1

  6. #6
    Board Regular masud8956's Avatar
    Join Date
    Oct 2016
    Location
    Dhaka, Bangladesh
    Posts
    147
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Unable to break external link

    Quote Originally Posted by petertenthije View Post
    Last thing i can think of are named ranges with external links in it.
    Right....links were hiding in named ranges. Problem solved.

    Thanks!

Some videos you may like

User Tag List

Tags for this Thread

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
  •