Unable to break external link

[masud8956]

Hi,

I have two workbooks. Both have one sheet with identical structure. So, for workbook 2, I just copied the sheet from workbook 1. There after I made amendments to workbook 2 formulas. These two workbooks are not required to be linked in any way. But every time I open workbook 2, I get a dialogue box asking me if I want to update the link.

I tried to get rid of this from Data Tab by 'Break Links' option but it does not work. Here to be mentioned that I also have some shapes in my worksheet.

How can I get rid of the external links?

TIA

 

[petertenthije]

Do these shapes perhaps contain links to outside sources?

Graphs are also a good place for external links to hide.

 

[masud8956]

No, I checked. Those shapes are not linked. I do not have any graphs as well.

 

[petertenthije]

Last thing i can think of are named ranges with external links in it.

 

[AhoyNC]

See if this reference on finding external links helps.
https://support.office.com/en-us/ar...workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

 

[masud8956]

Last thing i can think of are named ranges with external links in it.

Right....links were hiding in named ranges. Problem solved.

Thanks!