Professor Excel
break, links, hyperlinks, pivot, data validation, remove, conditional, formatting, excel

Break Links in Excel – All of Them (Even When Excel Doesn’t)

When you copy cells or worksheets from another Excel workbook, links to other worksheets in many cases still persists. Excel offers a function to break links but this function only works with links within formulas. There are many other types of links as links within conditional formatting rules or data validation rules. The bad news: Those links can’t be cut easily. The good news: there are still ways to break these links.