Forum Discussion

mtarler's avatar
mtarler
Silver Contributor
Apr 06, 2020
Solved

Hidden External Reference

So I think I'm pretty Excel savvy but this problem comes up every so often.  I have copied some info and/or sheets from another workbook and now this new workbook keeps saying it can't re-connect wit...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Apr 06, 2020
Try looking at the Name Manager (Ctrl+F3). There might be defined names that refer to an external workbook.
  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 06, 2020

    Twifoo  excellent suggestion, but unfortunately I already checked there also.  

    • mtarler's avatar
      mtarler
      Silver Contributor
      Apr 06, 2020

      now I've checked all the objects, graphs, and conditional formatting.  I've done additional 'find all' searches to no avail.  

      How can Excel be "smart" enough to tell me there is this missing link but not able to give me any hint as to where it is.

      BTW, at 1 point I was given the option to 'break the link' and did that but it still warns me. 

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Apr 07, 2020
        Select your preferred option in the Edit Links (Alt,A,K) dialog box, one of which is Break Links.