+ Reply to Thread
Results 1 to 3 of 3

Breaking Hidden Links

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    4,143

    Breaking Hidden Links

    There are 4 ways that an Excel File can link to another file.
    1. Formula
    2. Named Ranges
    3. Conditional Formatting
    4. Data Validation

    Formula links are easy to remove. Click on Data -> Edit Links and they are listed.

    Named Range links can be found by going to a blank sheet, pressing F3 and printing out the definitions. You can use Formulas -> Name Manager to remove or edit the link.

    Conditional Formatting and Data Validation Links are harder to find. The attached code helps with the effort. To use the code, go to a sheet and select the range of cells in which you suspect a link. Run the macro.

    The macro looks for both types of links. A cell that contains Conditional Formatting may have multiple triggers. The code finds them all and presents them. Data Validation links are shown with the range to which they reference.

    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Forum Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    4,330

    Re: Breaking Hidden Links

    Quote Originally Posted by dflak View Post
    Formula links are easy to remove. Click on Data -> Edit Links and they are listed.
    Not always easy to find or remove though! If you have an empty table column whose default formula links to another workbook, you can't remove the link unless you alter the default formula to something else.
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    4,143

    Re: Breaking Hidden Links

    OK, so one more thing to add to the list.

+ Reply to Thread

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