Apr 06 2020 09:53 AM
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 with the previous workbook. I have searched the entire workbook (including formulas), the entire VBA space, the data model (empty), existing connections (empty) and can't find this link anywhere. I do the Inspect Document for personal information and it also finds an external link, but I can't.
Any tips or suggestions?
thank you.
Apr 06 2020 11:07 AM
Apr 06 2020 12:28 PM
Apr 06 2020 01:40 PM
@Twifoo excellent suggestion, but unfortunately I already checked there also.
Apr 06 2020 06:06 PM
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.
Apr 07 2020 07:10 PM
Apr 07 2020 08:12 PM
@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.
Apr 07 2020 10:14 PM
@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
Apr 07 2020 10:15 PM
@mathetes just thought you might like to see the solution