I'm working with protected worksheets so manually replacing data is not viable.
I'm also stuck with 2010 so FORMULATEXT isn't available.

I agree with the validation statements. We're verifying that the correct equations are being used and referring to the correct cells. Everything looks fine until I try to print, then the file name is inserted into the formulas as Excel makes the references fully qualified.