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
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.
    • mtarler's avatar
      mtarler
      Silver Contributor
      Apr 07, 2020

      Twifoo  thank you again.  as I mentioned I already told Excel to break the link but it still warns me.  After I open the workbook I go to Alt, A (Data Tab) and 'Edit Links' is grayed out.

      I wish I could go into an editor and search the 'raw' code behind the workbook to find the link location.