< Back to screenshot
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,
will be replaced by
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.