AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED

[stan k]

I have an existing spreadsheet with multiple calcs.
If I copied an existing formula to the next line the answer is incorrect and
will copy the previous calculation as what was shown in the previous calc
solution. IE the calculation does not take into account the new variables.

[David]

Do you have the fomula set as absolute?

"stan k" wrote:

> I have an existing spreadsheet with multiple calcs.
> If I copied an existing formula to the next line the answer is incorrect and
> will copy the previous calculation as what was shown in the previous calc
> solution. IE the calculation does not take into account the new variables.