Linked to External Sources

[tlc53]

Hi,

When I open my main spreadsheet, it comes up that the workbook contains links to external sources. However, it shouldn't do! I have done multiple searches for formulas referring to external sources, none found. I have checked my Name Manager, no external links there. When I Edit Links, I can see it has one external link there. When I try to Break Link, it doesn't appear to do anything. After saving and re-opening the file it still refers to an external source link and the link is still showing under Edit Links. Is there anything else I can try? Thanks!

 

[offthelip]

Have you checked your addins?

 

[tlc53]

Have you checked your addins?

I don't think I have any Add-ins but I'm not familiar them. Where do I go to check?

 

[offthelip]

in Excel 2010
File/options/Addins
In other versions the way to get to options is one of those things that MS keep on changing, so I don't know about later versions

 

[RoryA]

Usually something like that is caused by chart data sources, data validation, or conditional formatting. If you have Tables in the workbook and any of them had a column whose default formula referred to another workbook, that can also be a cause, and is quite hard to break, but I'd start with the first three items.

 

[tlc53]

Usually something like that is caused by chart data sources, data validation, or conditional formatting.

Thanks so much for your post! It was because of conditional formatting and I have now been able to break all external links. I wouldn't have thought to have looked there. Thank you

 

[RoryA]

Glad to help.