+ Reply to Thread
Results 1 to 4 of 4

Unable to find an invalid external Link

  1. #1
    Registered User
    Join Date
    03-03-2005
    Posts
    41

    Unable to find an invalid external Link

    Excel 2016
    Opening a workbook identifies a link to an earlier version of this workbook
    Data->Links confirms this link to an earlier version of this workbook
    THe workbook is not protexted. None of the sheets in teh workbook are protected.

    I click change source, select the current version (actually the workbook that is open and in which I am trying to make this change)
    click OK but the reference does not change

    I have searched the workbook for this reference but it cant be found
    I have searched the workbook for [ and it finds a number of references to the current workbook [they are in cell A1 on different sheets which contains the function Cell("filename"] but none to the earlier version identified by edit->link

    I simply cant find the cell with the link

    I search the text in my macros and vba code but cant find the reference there

    So I go for 'Break Link'. Accept the warning
    But data->edit link continues to report the same link
    File save and Open
    But data->edit link continues to report the same link

    So please how can I find this link and make the problem go away?

    TFAI
    Last edited by RincewindWIZZ; 03-03-2020 at 08:33 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Unable to find an invalid external Link

    I've encountered this from time to time.

    Often it's a defined range name that contains the link, or sometimes a shape object which might be hidden or reduced to a very small pixel size that contains a hyperlink.

    The other approach I often use is a repeated binary reduction of first sheets, then columns then rows. i.e. delete half the sheets and see if that solves the problem, if not re-open the workbook and delete the other half of the sheets. If that solves the problem then re-open the workbook and delete half of the previous half of the sheets you deleted...etc. Eventully you'll identify a single sheet wherein the link lies. Then adopt the same approach to deleting half the rows, and then half the columns. At some stage it should then become apparent what's causing the problem.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-03-2005
    Posts
    41

    Re: Unable to find an invalid external Link

    That's a bit depressing :-(! This is stone age debugging technique! I thought MS had moved on from that!
    Good job its only a small workbook (20 sheets; 200 rows, 400 columns!)

    No range names; no objects (other than the usual workbook things)

    Oh well, if that's the only way - didn't have much else to do today!!

    Not sure I am than keen on your "At some stage it should then become apparent . . ."
    its the 'should' that is bothering me!

  4. #4
    Registered User
    Join Date
    03-03-2005
    Posts
    41

    Re: Unable to find an invalid external Link

    Cracked it. Thank you.
    Somehow a link had got into a conditional format!
    And that's weird as links are not allowed in conditional formats!Cond Fmt with Link.jpg
    Last edited by RincewindWIZZ; 03-03-2020 at 10:51 AM. Reason: Addn info

+ 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. [SOLVED] Cannot Find Link to External Workbook
    By brandonboucher in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-04-2018, 06:33 PM
  2. [SOLVED] Can't find External Link
    By grey in forum Excel General
    Replies: 3
    Last Post: 02-01-2017, 07:17 AM
  3. Replies: 2
    Last Post: 09-29-2014, 01:14 AM
  4. [SOLVED] How to Find Cells With a Given External Link
    By EddieN1 in forum Excel General
    Replies: 2
    Last Post: 11-21-2013, 01:58 PM
  5. Unable to find / remove link to external workbook
    By jpruffle in forum Excel General
    Replies: 3
    Last Post: 08-09-2011, 11:41 AM
  6. How to find where External Link is in file?
    By monkey2003 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-18-2009, 05:19 PM
  7. Find a link to an external file
    By Tadashii in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 06:05 AM

Tags for this Thread

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