Thursday, August 27, 2015

finding and breaking external excel links

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

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.

No comments:

Post a Comment