+ Reply to Thread
Results 1 to 6 of 6

Cannot Find External Links in Workbook

  1. #1
    Registered User
    Join Date
    03-07-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    7

    Cannot Find External Links in Workbook

    Hi,

    My excel says that I have linked workbooks and asks me to update them (the 'Inquire' addiin workbook relationship also lists 4 related workbooks) . I cannot find out how they are related and hence cannot remove them from being linked.
    Please help and note I have already tried the following to identify the link but to no avail:
    1) I deleted all worksheets in my workbook so now i have only one blank 'Sheet 1'.. still not solved
    2) I deleted all things listed in Name Manager...still not solved
    3) Nothing in conditional formatting/data validation...still not solved
    4) Charts /shapes...everything deleted so none....still not solved
    How can it still be showing as linked? where are these links and how to remove? Please see output of Inquire workbook analysis showing 6 linked workbooks with nothing else there:
    Summary

    lease see output of Inquire workbook analysis showing 6 linked workbooks where as I have removed everything:
    Summary
    Item Value Reviewer Comments
    Creation Date 11 February 2019 15:08:51
    Modified Date 07 March 2019 15:46:10
    File Size (bytes) 26,438
    Title
    Author NA
    Linked Workbooks 6
    DDE Links 0
    Data Connections 0
    Visible Sheets 1
    Hidden Sheets 0
    Very Hidden Sheets 0
    Formulas 0
    Array Formulas 0
    Formulas With Errors 0
    Formulas With Logical Values 0
    Formulas With Numeric Values 0
    Formulas With Date/Time Values 0
    Formulas With Textual Values 0
    Formulas With Numeric Constants 0
    Formulas With Textual Constants 0
    Formulas With Nested IF Statements 0
    Formulas Without Cell References 0
    Formulas Referencing Blank Cells 0
    Formulas Referencing Hidden Cells 0
    Formulas Referencing Text Cells 0
    Formulas Referencing External Workbooks 0
    Formulas Formatted As Text 0
    Positive Formulas 0
    Negative Formulas 0
    Unique Formulas 0
    Duplicate Formulas 0
    Inconsistent Formulas 0
    Cells With Dependents 0
    Cells With Textual Constants 0
    Cells With Numeric Constants 0
    Cells With Comments 0
    Cells With Validation Criteria 0
    Cells With Conditional Formatting 0
    Cells With Numerics Stored As Text 0
    Invisible Cells 0
    Used Input Cells 0
    Unused Input Cells 0
    Occupied Cells 0
    Merged Cells 0
    Blank Cells 0
    Blank Referenced Cells 0
    Unlocked Cells 0
    Hidden Rows and Columns 0
    Named Items 0
    Named Items With Errors 0
    Warnings 1

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Cannot Find External Links in Workbook

    Go to the Data menu, and check the Queries & Connections section. If Edit Links is clickable, check that for the linked workbooks. If not, check the Queries & Connections button to see if it lists anything.

  3. #3
    Registered User
    Join Date
    03-07-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    7

    Re: Cannot Find External Links in Workbook

    Checked there are no Queries and Connections. The edit links is now not clickable because I have deleted all the worksheets (it was clickable before but only shows 2 external workbooks (not the other 6 which inquire finds - which I knew I had links to).

  4. #4
    Registered User
    Join Date
    03-07-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    7

    Re: Cannot Find External Links in Workbook

    I have used the findlink add-in and it has found the links in hidden names objects, however these are not in any worksheet (as i only have one blank worksheet).
    The findlink can find and remove theses, however I want to remove it manually and cannot find these hidden links on my own - is there any way in excel?

  5. #5
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Cannot Find External Links in Workbook

    I believe you would have to unhide the names using VBA, and then you could access them in the Name Manager. Something like this might work (please note, this is untested):
    Please Login or Register  to view this content.
    You can access the VB Editor with alt+F11. Put this in ThisWorkbook, place your cursor in the sub, and hit F5. In theory, this will unhide all defined names, and allow you to delete them from the Name Manager.

  6. #6
    Registered User
    Join Date
    03-07-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    7

    Wink Re: Cannot Find External Links in Workbook

    This worked! Thanks!!

+ 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. Remove external links that I cannot find
    By dcoates in forum Excel General
    Replies: 3
    Last Post: 06-01-2018, 10:22 AM
  2. Can't find external links or remove them.
    By fastcar in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-21-2017, 04:35 AM
  3. Replies: 1
    Last Post: 09-27-2017, 04:29 PM
  4. Find all external links in workbook?
    By OldManExcellor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2014, 03:08 AM
  5. Log of External Links in the workbook
    By DUKE888 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2011, 10:49 AM
  6. External workbook links
    By Lizabeta in forum Excel General
    Replies: 0
    Last Post: 03-18-2011, 12:37 PM
  7. Find and change external links to point to the same workbook instead
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2005, 02:05 PM

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