Excel Link RescueExcel Link Guides
Practical guides for finding, understanding and repairing external workbook links in Excel. Each one covers the method Excel gives you first, then the cases where that method runs out.
-
Find external links in Excel
Where external workbook references hide, how to search for them in formulas, defined names and charts, and how to list every linked source file at once.
-
Fix broken links in Excel
Why a workbook link stops working, how to repoint it in Excel, and what to check before and after a repair on a workbook you cannot afford to damage.
-
Change the source of an Excel workbook link
Excel's Change Source workflow, what it does to your formulas, and how to see the old and new paths side by side before anything is written.
-
Change multiple Excel link sources at once
The difference between many references to one file and many different source files, and how to handle both without repeating the same dialog dozens of times.
-
Fix Excel links after moving files
What happens to workbook links when a folder is reorganised, a drive letter changes or a model is copied to another computer, and how to point every reference at the new location.
-
External links in .xlsm files
Repairing workbook links in a macro-enabled file, and how to confirm afterwards that the VBA project came through unchanged.