A6 MATCH D2 B2. If you find any simply remove or break those particular links. If you have a formula that is pulling data from elsewhere you can jump to that other cell.
B6 0.
The add-in is called Excel PowerUps. Here are the steps to find external links in these places. This often works well. With your excel sheet opened navigate to the Home tab Find Select Go To Special.