Unable to break external link

masud8956

Board Regular
Joined
Oct 22, 2016
Messages
147
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

Board Regular
Joined
Sep 25, 2012
Messages
139
Do these shapes perhaps contain links to outside sources?

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

masud8956

Board Regular
Joined
Oct 22, 2016
Messages
147
No, I checked. Those shapes are not linked. I do not have any graphs as well.
 

Forum statistics

Threads
1,077,768
Messages
5,336,143
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top