Remove links to other workbooks
Every opening asks whether to update links to a file that no longer exists, or sits on a colleague's drive. We break the links the way Excel would: every formula pointing to another workbook is replaced by its last value.
What this tool does
- The list of linked workbooks, with their path and the number of cells that depend on them.
- Formulas pointing to another workbook replaced by their last value; other formulas stay.
- Defined names pointing to another workbook, removed.
- The fixed file is read back: every value is the same as before.
What it does not do: If a drop-down list, a conditional format or a chart points to the other workbook, nothing is touched and the screen says where: breaking the link would leave them pointing nowhere, and Excel would "repair" the file on opening.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Slim down a workbook : Phantom rows, thousands of styles, copied formatting: the extra weight, removed.
- Formulas to values : Paste Special, Values, on the whole workbook at once: the file is frozen.
- Unmerge cells : Merges removed and the value copied everywhere: you can finally sort and filter.
- Recover a damaged file : The repaired workbook when possible, and always the data that could be read.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.