ExcelBanter - problem with replicate formula

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - problem with replicate formula (https://www.excelbanter.com/excel-worksheet-functions/73735-problem-replicate-formula.html)

rfoster6

problem with replicate formula

When i replicate a formula the formula is correctly changed using relative
cell addressing, however rather than calculating the new value it copies the
original value.

Niek Otten

problem with replicate formula

ToolsOptionsCalculation, check Automatic

--
Kind regards,

Niek Otten

"rfoster6" wrote in message
...
When i replicate a formula the formula is correctly changed using relative
cell addressing, however rather than calculating the new value it copies
the
original value.

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