whatever the original formulas were, they were returning an error-either they were mistyped or they were udfs and macros were disabled for instance. when you copy and paste values you just end up with the returned error value