Unable to break external link

masud8956

Board Regular
Joined
Oct 22, 2016
Messages
155
Office Version
2016, 2011, 2007
Platform
Windows
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
163
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
155
Office Version
2016, 2011, 2007
Platform
Windows
No, I checked. Those shapes are not linked. I do not have any graphs as well.
 

Forum statistics

Threads
1,086,138
Messages
5,388,079
Members
402,100
Latest member
Rizwan ul haq

Some videos you may like

This Week's Hot Topics

Top