Externally Linked Formulas (and other things)
One frequent question/complaint about links is 'How do I find which cells are linked to external workbooks?'
Codematic Link Manager finds them all, not just those in visible formulas, hidden sheets, hidden cells, defined names, charts, drawing objects, everything is searched for possible links to external workbooks. Double click the cell address to look at the formulas or object in place, click the green arrow in the toolbar to come back to the report.
(This feature is only available in the commercial version)
Breaking External Links
With no tools to help an unexpected External Links warning can be a real headache.
People are often advised to use the break links feature from the Excel Edit Links dialog to remove these unwanted links. That is very dangerous advice.
Breaking a link overwrites the formula with its value. It is essential to the integrity of the model to ensure it is safe and appropriate to do that. Many times that is the exact wrong thing to do. If a link has been picked up accidentally it is important to find where it is, and what it should be. Often it should be linked to a cell in the current workbook, rarely should it be blindly replaced with its current value - especially if that is currently an error.
For this reason we recommend using the Link Manager to find all the links and then deal with each as appropriate. The Link Manager can be used to point external links back to the current workbook by setting the replacement path and name to those of the current workbook.
The linked workbook report can also be useful documentation to understand which workbooks the current one depends on. Some clients have inserted the report sheet into the workbook to which it refers as a form of documentation.
You can dopwnload the free demo version of the Codematic Link Manager here.