PopTools logo

Fix bad references

Use this routine to remove all occurrences of bad references in the current worksheet. When you press “Go”, all occurrences of path names will be removed from both standard and array formulas. For example,

='C:\Program files\Mattools\Mattools.xla'!NormalDev(10,2)

will be replaced by


This routine is useful when worksheets made with PopTools are transferred to another computer. Excel sometimes stores the full path to a function in an add-in, and therefore if the add-in changes name or location, Excel will be unable to find the function. Sometimes the Excel “Edit links” routine can fix the problem, but if it fails, this routine usually fixes the problem.

Footer image - matrix analysis