ExcelBanter - AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED (https://www.excelbanter.com/excel-programming/322524-autocalculation-excel-not-working-when-formulas-copied.html)

stan k

AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED

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

AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED

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.

All times are GMT +1. The time now is 09:09 PM.