Excel External Link

I have a workbook(let us say Workbook A), two sheets are copied from another workbook (let us say Workbook B)

Let us say there is a sheet called ABC in Workbook B, and cell A1 links to another sheet DEF in Workbook B. I clicked the tab name ABC and copied ABC to Workbook A, and I also copied DEF from Workbook B to Workbook A.

Now every time I open Workbook A, the window pops up (see attached screenshot). I have changed Workbook A sheet ABC cell A1 to link to workbook A sheet DEF, the same window still pops up when I open the file. Even if I deleted workbook A sheet ABC cell A1, the window still pops up.

Maybe there are some other links in Workbook A sheet ABC, but I just could not find it, I have looked over and over again. How can I find which cells/buttons have external link? (Note: there are some VBA buttons in sheet ABC, I have copied the code from Workbook B to Workbook A, and assign macro in Workbook A to each button in workbook A sheet ABC.)

I have done too much work on Workbook A Sheet ABC, and don't want to delete it and do it again.

Please help and tell me how to find the external links?

Thanks.

If you want to get rid of the links, go to Data -> Edit Links and click on the Break Link button.

It's an annoyance for me on one of the reports I get too. So that's how I knew about it .