I have a workbook (A) that has formulas with links to other workbooks (B). In the instance where you move one of these B workbooks to a different folder, workbook A, upon opening, will give you a warning that there's a link that it can't update. It will then open an Edit Links dialog box showing links that exist in the A workbook, and it shows which links are ok, and which aren't. In this dialog box you're given some options of breaking a link, going to the source, etc. But how can you find where in this sheet A is the formula that's the culprit??
Solved by B. F. in 27 mins