Tip Printed from ExcelTip.com

---

Finding and Deleting Unwanted and Orphaned Links


To find unwanted links created by range Names:

1. Select a cell in the sheet.
2. Press F3, and click Paste List.
3. Check the list, and identify any defined Names you want to delete.
4. Press Ctrl+F3.
5. Select each Name, and click Delete (you cannot delete all of them at once).

To find unwanted links:

1. Press Ctrl+F.
2. In the Find box, type a [ (every externally linked formula has a square bracket).
3. Start the search, and delete any unwanted formulas (carefully!).
To check the Edit Links dialog box:
1. From the Edit menu, select Links.
2. Select the source workbook whose links you want to delete, and then click Change Source.
3. In the folder, select the workbook you are currently working in (that is, link the workbook to itself), and click OK.

To save the workbook under a new name:

If cells are having links to a non-existing workbook that is not shown in the Edit Links dialog box, there is a solution.
1. Save the workbook containing the links, using the name of the workbook to which it is linked. The links are automatically deleted (the new workbook is linked to itself).
2. Save the workbook again while renaming it.