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

Maybe there are macros that are doing this conversion.

I'd open that workbook with macros disabled (change your security to medium) and
answer No to the enable macro prompt.

If none of your formulas are overwritten, then it's time to find out why those
macros exist and if they've overstayed their welcome. (and how they should
change or if they should be deleted).

Ned wrote:
>
> 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

--

Dave Peterson

Dave,

Thanks for the advice. I tried disabling the macros and also deleting them
from the file, but I am still having the same problems. I am not sure what
else could be causing this strange problem.

best,
Ned

"Dave Peterson" wrote:

> Maybe there are macros that are doing this conversion.
>
> I'd open that workbook with macros disabled (change your security to medium) and
> answer No to the enable macro prompt.
>
> If none of your formulas are overwritten, then it's time to find out why those
> macros exist and if they've overstayed their welcome. (and how they should
> change or if they should be deleted).
>
> Ned wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>

One way to make sure all macros are disabled is to open excel in Safe mode:

Windows start button|Run
Excel /safe

Then file|open your workbook and see what happens.

I don't have any better guesses right now.

What do your formulas look like--just in case there's something special about
them?



Ned wrote:
>
> Dave,
>
> Thanks for the advice. I tried disabling the macros and also deleting them
> from the file, but I am still having the same problems. I am not sure what
> else could be causing this strange problem.
>
> best,
> Ned
>
> "Dave Peterson" wrote:
>
> > Maybe there are macros that are doing this conversion.
> >
> > I'd open that workbook with macros disabled (change your security to medium) and
> > answer No to the enable macro prompt.
> >
> > If none of your formulas are overwritten, then it's time to find out why those
> > macros exist and if they've overstayed their welcome. (and how they should
> > change or if they should be deleted).
> >
> > Ned wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson