Excel formula randomly changes to hard-code number
I am having an issue with an Excel model that was orginally written by some
of my predecessors at work. I do not know the complete history of the file,
but it would be extremely time consuming to recreate.
When I change certain values in the model some formulas randomly disappear
and are replaced by hard-code numbers.
The numbers are the right result of the formula, but the formulas are
overwritten with the result. If I retype the formulas they will sometimes be
fine and other will go back to a hrad-code number.
thanks for any assistence.
Ned
|