+ Reply to Thread
Results 1 to 3 of 3

Break Links

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    Victoria, BC Canada
    MS-Off Ver
    365 Business
    Posts
    14

    Break Links

    I have inadvertently created a link between spreadsheets.
    How in god's name do you get rid of this?
    There is a horribly mis-named feature called 'break link' which does NOTHING other than waste our time.
    Is there some other method someone could let me know about?
    Thanks!!!

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,302

    Re: Break Links

    the link is probably hidden somewhere else in the sheet.
    check the named ranges, the conditional formatting and the data validation and pivot table sources.

    You could also upload a sheet and we could find it (obviously stripping out all the formula and data for your privacy).
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Break Links

    Insert this code into the VBA editor and run the macro
    Please Login or Register  to view this content.
    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. Edit Links - Break Links not working
    By dmang1 in forum Excel General
    Replies: 10
    Last Post: 03-16-2017, 12:43 PM
  2. Break links within one cell but not all the links...
    By kgallo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2016, 12:11 PM
  3. Break some links within a cell, but not all links...
    By kgallo in forum Excel General
    Replies: 2
    Last Post: 08-22-2016, 06:09 PM
  4. Completely remove/delete all the external links (Break Links)
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 05:31 AM
  5. Break Links
    By Katiek9 in forum Excel General
    Replies: 0
    Last Post: 07-19-2011, 10:33 AM
  6. break links
    By keith6292 in forum Excel General
    Replies: 2
    Last Post: 12-12-2009, 04:26 PM
  7. [SOLVED] break links
    By peadar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 09:06 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