+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3
Results 31 to 35 of 35

Excel file won't break links

  1. #31
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,829

    Re: Excel file won't break links

    Ankur.newid welcome to the forum

    Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  2. #32
    Registered User
    Join Date
    03-16-2016
    Location
    London
    MS-Off Ver
    2013
    Posts
    34

    Re: Excel file won't break links

    Great information, thanks! I've been struggling for weeks for this solution!

  3. #33
    Registered User
    Join Date
    02-25-2019
    Location
    NYC
    MS-Off Ver
    1902
    Posts
    1

    Re: Excel file won't break links

    Quote Originally Posted by benalt View Post
    I found the solution. I went to File / Check for issues / Check compatibility which gave me 2 results. The second result said "One or more cells in this workbook contain data validation rules which refer to values on other worksheets...". I clicked on the "Find" button which brought me to 2 adjacent cells with pull down menus. Clicking on "Data Validation" / "Circle Invalid Data" from the "Data" tab put circles around those cells. I clicked on each cell individually and then selected "Data Validation" and it showed that the source line was referencing the other file. I manually removed the file reference from the source and then went back in to "Edit Links" and clicked on "Break Link" again and this time it removed the link!

    Lesson: "Break Link" cannot remove links that are in data validation rules.
    Many thanks - This worked for me as well. It actually was also pointing to data validation rules that were met, and therefore didn't show up circled as well.

    One tip that made it easier, was to copy the cells I removed validation for to other sheets causing the same problem in order to save time, once cleared.

  4. #34
    Registered User
    Join Date
    07-23-2019
    Location
    Seattle, WA
    MS-Off Ver
    Office365
    Posts
    1

    Re: Excel file won't break links

    I had the same issue but could still not break links after going through these suggestions. I realized that I had a Custom Sort List that was created in another workbook file. When I delete that, then it solved the problem -- no more unknown external links. Go to File > Options > Advanced > Scroll way down to the General section and click Edit Custom Lists > select the offending list > hit Delete.... or else Go to Sort & Filter > Custom Sort > Sort Order drop-down > Custom Lists > select the offending list > hit Delete > cancel the sort.

  5. #35
    Registered User
    Join Date
    12-03-2013
    Location
    Adelaide Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel file won't break links

    Thanks Udaman! The Name Manager was the source of my problems. Delete the range with a reference to another sheet and the link was gone.

+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3

Thread Information

Users Browsing this Thread

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

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