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 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.

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

    Riny_van_Eekelen  THANK YOU !!!  It actually found multiple cases of hidden references I hadn't found!  Even though a couple of them it failed to delete I was able to use the list option for it to tell me where to go and in 1 case I had to use VBA to pull it out (it was a hidden name) and eventually I was able to change the value.  THANK YOU for putting me on to this and THANK YOU to Bill Manville Associates who actually wrote the software