search values in named formulas

[Robert H]

I recieve worksheets that are exported from a user in the field and I
import the worksheet to a master workbook. The Master and Field
workbook have the same named ranges and named formulas. The imported
workbook's named formulas refer back to the field workbook. manualy
correcting the named formulas is very time consuming and easy to screw
up.

Has anyone sucessfully created code to find and replace in names? Or
have sugestions as to how to deal with this?

Thanks
Robert