< Back to screenshot

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

=NormalDev(10,2)

This routine is provided primarily to fix references to an older version of PopTools called "Mattools". Excel 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.