+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 27 of 27

Excel file won't break links

  1. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,015

    Re: Excel file won't break links

    The thread is over three years old, and is marked as solved.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  2. #17
    Registered User
    Join Date
    04-25-2017
    Location
    Fort Worth, Texas
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Excel file won't break links

    No worries. Thank you so much. Just getting my feet wet here so forgive the learning curve. Thanks for all you do!

  3. #18
    Registered User
    Join Date
    08-01-2017
    Location
    Bandung, Indonesia
    MS-Off Ver
    2016
    Posts
    1

    Thumbs up Re: Excel file won't break links

    WOW THANKS! It works perfectly for me

  4. #19
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    34

    Re: Excel file won't break links

    Is anyone aware of any other places that broken links can be lurking besides within formulas, the Name Manager, Data Validation, or Conditional Formatting mentioned above? I'm trying to find a broken link in one of my inherited files and it is not coming up in any of these things.

  5. #20
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    9,929

    Re: Excel file won't break links

    jdriscol,
    Unfortunately your post does not comply with Rule 2 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.
    Ben Van Johnson

  6. #21
    Registered User
    Join Date
    01-04-2018
    Location
    Tenerife
    MS-Off Ver
    Office360
    Posts
    7

    Re: Excel file won't break links

    I follow all the steps but is still have links that do not break. As final trial i started to delete sheet by sheet to try to find where the link were but this did not help. In some case the links disappeared deleting one sheet, in some cases deleting a different one. So i`m back to square one. I can`t sort this out. Any other advise?

  7. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,015

    Re: Excel file won't break links

    @Topacciolo - unfortunately your post does not comply with Rule 2 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.

  8. #23
    Registered User
    Join Date
    01-04-2018
    Location
    Tenerife
    MS-Off Ver
    Office360
    Posts
    7

    Re: Excel file won't break links

    Done! Sorry, i thought it was the opposite... I created a new post for this. thanks for your advise.

  9. #24
    Registered User
    Join Date
    08-03-2018
    Location
    White Lake, Michigan
    MS-Off Ver
    2016
    Posts
    1

    Re: Excel file won't break links

    Here's how I fixed mine:

    FIND THE CULPRIT:
    1) Make a work copy of your problem file
    2) Systematically delete one sheet, save/close the work file, then reopen the file
    a) If the message appears upon opening, delete another sheet, save/close and open the file
    b) repeat this process until the error no longer appears upon opening the file
    c) Make note of the sheet that was deleted that caused the pesky message to stop appearing.
    3) Once the error stops appearing, go back to the original problematic fie and save it as the work version again. Now you know what sheet needs to be fixed.
    NOTE) If there is no conditional formatting on the problematic sheet, this solution is not for you.

    THE FIX
    4) Click on "Conditional Formatting" on the Styles ribbon to open the Conditional Formatting Rules Manager window
    5) From the dropdown, select "This Worksheet"
    6) For each rule, click "Edit Rule" and be sure none of them reference a file. You should be able to cleanly delete any rules that do. Don't try to fix them...they are extraneous.
    7) Save this work file, close it, and reopen it to make sure the error doesn't appear. If it does, rinse and repeat.
    8) If all is well, you can safely overwrite the problematic version with the fixed work version.

    Note: I guess it may be possible to have more than one sheet be a problem. Use your analysis skills to identify sheets that are culprits if the one-by-one system doesn't get it for you.

    GOOD LUCK! The developers should provide some sort of assistance to finding these little hidden problems.
    Last edited by songjockey; 08-03-2018 at 11:37 AM. Reason: clarity

  10. #25
    Registered User
    Join Date
    12-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    71

    Re: Excel file won't break links

    MGDASKOS was the person that asked the new question in this thread. MGDASKOS, your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

  11. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,015

    Re: Excel file won't break links

    Thanks for spotting this, however the post in question is two years old and was the only post ever made by that member. As such, it does not require any follow-up.

  12. #27
    Registered User
    Join Date
    10-03-2018
    Location
    London, England
    MS-Off Ver
    2013
    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.
    Thank you!!!!!!!!!!!! Really, really appreciated sharing this!!!!!!!!!!! Worked for me :D

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 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