+ Reply to Thread
Results 1 to 5 of 5

'Links to other sources' message cannot be resolved, cannot find the 'links'

  1. #1
    Registered User
    Join Date
    07-10-2014
    Location
    East Sussex, England
    MS-Off Ver
    2007, 2010
    Posts
    51

    'Links to other sources' message cannot be resolved, cannot find the 'links'

    When opening a 2007 workbook that I have inherited from someone else, it always opens a warning message: This workbook contains one or more links that cannot be updated.
    • To change the source of links, or attempt to update values again, click Edit Links.
    • To leave the link as is, click Continue.

    see attachment:

    Warning message.JPG

    If i click Edit Links, I get this:

    Edit Links.JPG

    Now what? Please help. Thanks!

    Robbo

  2. #2
    Registered User
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: 'Links to other sources' message cannot be resolved, cannot find the 'links'

    Are you just trying to remove the link so the error message does not show anymore? You may want to check the Name Manager in the Formula tab to see if there is a named range that references a different source.

  3. #3
    Registered User
    Join Date
    07-10-2014
    Location
    East Sussex, England
    MS-Off Ver
    2007, 2010
    Posts
    51

    Re: 'Links to other sources' message cannot be resolved, cannot find the 'links'

    That's correct, just trying to remove the link. But more in detail, I would like to know how one is expected to 'search' a workbook for links. I tried using the Ctrl+F Find tool to look for [] square brackets, in formulas, that would denote a reference to another workbook, and found nothing there.
    Robbo

  4. #4
    Registered User
    Join Date
    07-10-2014
    Location
    East Sussex, England
    MS-Off Ver
    2007, 2010
    Posts
    51

    Re: 'Links to other sources' message cannot be resolved, cannot find the 'links'

    It has worked. It was a link in a named range. Thank you, thank you, oh thank you.

  5. #5
    Registered User
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: 'Links to other sources' message cannot be resolved, cannot find the 'links'

    You are most welcome. I learned that from a very frustrating experiance. As for searching a workbook for links I cant remember off the top of my head. But as far as I can tell if its in a named range you wont find it by searching.

+ 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. Replies: 23
    Last Post: 11-05-2021, 12:34 AM
  2. Edit Links Alert Message but no links
    By ericad in forum Excel General
    Replies: 0
    Last Post: 12-22-2011, 11:41 AM
  3. Replies: 2
    Last Post: 10-23-2010, 08:36 AM
  4. Replies: 3
    Last Post: 05-10-2006, 07:35 AM
  5. [SOLVED] Links to other data sources
    By Graham Haughs in forum Excel General
    Replies: 2
    Last Post: 02-25-2006, 10:00 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