View Single Post
  #1   Report Post  
Ned
 
Posts: n/a
Default 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