professor-excel.com
Break Links in Excel – All of Them (Even When Excel Doesn’t)
Excel doesn't break all your links: You have to break links within data validation rules, named ranges, conditional formatting or Pivot Tables manually.