finding and breaking external excel links

Apart from the great tips all over the internet such as this one

http://tjshome.com/blog/249/guide/excel/accounting

I find very common when using conditional formatting and copy/pasting from one sheet to another that this link gets created with a reference to the original file. Break links doesn't really break them. Find them by clicking on

Home ribbon, Conditional Formatting, Manage Rules

change the "Show formatting rules for:" drop down to "This worksheet" and look for anything referencing a file instead of a rule, like in this case:

Change the formatting and you are set.